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
 
G

Guest

Private Sub CheckBox1_Click()

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

End Sub


"DanHegarty" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making A form tab invisible/visible with a check box 2
Make fields visible and invisible on check box 4
Have a text box 'float' over a sheet 2
check box makes text box visible 6
comments box gets chopped off by freeze panes! 2
Option to change a control from invisible to visible 5
Invisible to Visible SubForm 1
Can a mouseover be used to make a layer visible/invisible? 2

Top