Restoring Cell comments status

  • Thread starter Thread starter Barry Smith
  • Start date Start date
B

Barry Smith

I have an application where I store a users preferences before I
remove menus and toolbars. I store these on a sheet on the wookbook.
When I close the spreadsheet and restore the user settings, I find
that comments are restored as all shown, or all not shown. When they
load a previous workbook that had some cell comments shown and some
not shown it now has all one or the other. How do you do this? Do I
not store the user preference?
 
Barray,

As far as I know : Changing the checkbox in Tools / Options / tab View /
Comments ( None , Indicator only , Comment & Indicator) will change the
status of all the comments. You can then (per cell) change the status.
If you want to do this by VB : Range("A1").Comment.Visible = TRUE or FALSE
You can save/retrieve the status of all the comments by using the collection
of comments and loop through it.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show cell value as cell comment, by mycomment() ro any 3
Code to add comments to selected cells within a selected range 30
Excel Import Comments 3
GridLines Inadvertantly Goes Away with Macro 3
Link comment boxes based on different cell values 9
Show Excel comment on mouseover but not the comment indicator 7
update all hyperlinks to another drive 1
Excel 2007 'Copy as Picture' doesn't paste at 100% 1

Back
Top