Check Box to switch make comments visible or invisible

D

DanHegarty

Hey guys,

I'm trying to create a check box that will control the visibility o
comments on a sheet. I've recorded some macros to this effect but the
seem to only work a couple of times and then stop. Also they never wor
when attached to the check box.

Many thanks in advance

da
 
E

excelent

Private Sub CheckBox1_Click()

If Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If

End Sub


"DanHegarty" skrev:
 
Top