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

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