Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show/hide comments
Hi,
i've got comments on my worksheet and was wandering if there is a way to show/hide comments through a command button or by assigning a macro to an image. I know that you can easily do this by select show/hide comments on the toolbar but as the users of my spreadsheet know nothing about excel i've been told to include this in the actual spreadsheet. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show/hide comments
Record a macro when you do this manually (one for show and one for hide).
Then plop a couple of buttons from the Forms toolbar onto your worksheet and assign the macros to the buttons. Dal wrote: Hi, i've got comments on my worksheet and was wandering if there is a way to show/hide comments through a command button or by assigning a macro to an image. I know that you can easily do this by select show/hide comments on the toolbar but as the users of my spreadsheet know nothing about excel i've been told to include this in the actual spreadsheet. Thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
show/hide comments
Hi,
Put a button on your sheet then add this code to it to toggle the comments on/off. Sub Button1_Click() If Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then Application.DisplayCommentIndicator = xlCommentAndIndicator Else Application.DisplayCommentIndicator = xlCommentIndicatorOnly End If End Sub Mike "Dal" wrote: Hi, i've got comments on my worksheet and was wandering if there is a way to show/hide comments through a command button or by assigning a macro to an image. I know that you can easily do this by select show/hide comments on the toolbar but as the users of my spreadsheet know nothing about excel i've been told to include this in the actual spreadsheet. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I set the show/hide default for comments in Excel? | Excel Discussion (Misc queries) | |||
Some comments stay hidden even after picking show/hide all why? | Excel Discussion (Misc queries) | |||
Tools/Customize question - toggle Show/Hide Comments without a macro | Excel Programming | |||
Show/Hide Comments Not Working | Excel Discussion (Misc queries) | |||
Hide cells with comments in them. | Excel Discussion (Misc queries) |