Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restoring Cell comments status
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restoring Cell comments status
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 * "Barry Smith" wrote in message om... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the Status of Cell | Excel Discussion (Misc queries) | |||
Status bar disappears when restoring screen size | Excel Discussion (Misc queries) | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
Display worksheet protection status in a cell? | Excel Worksheet Functions | |||
Lock Cell status | Excel Discussion (Misc queries) |