Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box to switch make comments visible or invisible
Hey guys, I'm trying to create a check box that will control the visibility of comments on a sheet. I've recorded some macros to this effect but they seem to only work a couple of times and then stop. Also they never work when attached to the check box. Many thanks in advance dan -- DanHegarty ------------------------------------------------------------------------ DanHegarty's Profile: http://www.excelforum.com/member.php...o&userid=35279 View this thread: http://www.excelforum.com/showthread...hreadid=550631 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box to switch make comments visible or invisible
Private Sub CheckBox1_Click()
If Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then Application.DisplayCommentIndicator = xlCommentAndIndicator Else Application.DisplayCommentIndicator = xlCommentIndicatorOnly End If End Sub "DanHegarty" skrev: Hey guys, I'm trying to create a check box that will control the visibility of comments on a sheet. I've recorded some macros to this effect but they seem to only work a couple of times and then stop. Also they never work when attached to the check box. Many thanks in advance dan -- DanHegarty ------------------------------------------------------------------------ DanHegarty's Profile: http://www.excelforum.com/member.php...o&userid=35279 View this thread: http://www.excelforum.com/showthread...hreadid=550631 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Drop-down list - make arrow visible at all times | Excel Discussion (Misc queries) | |||
Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
better search: "make worksheet visible" | Excel Discussion (Misc queries) |