Conditionally Hiding Comment markers.

[Paul]

Is there a way to hide comment markers? If so, can they be hidden based
on cell values or formulas? I created a worksheet where some cells are
hidden until a specified second cell contains a given value. However, while
cell values are hidden the comment marker gives away the fact that the cell
may contain data or serves some special function.

 

[JLGWhiz]

From the Excel help file:
1.. On the Tools menu, click Options, and then click the View tab.
2.. Do one of the following:
To hide both comments and indicators throughout the workbook, click None
under Comments.

 

[JLGWhiz]

From the VBA help file:

Application.DisplayCommentIndicator = xlNoIndicator

 

[Paul]

Thanks for the info JLG. However, your solution is an all or nothing option.
I would like the comments to show when the cell has focus but hide the
indicators.
Any ideas?

 

[Brad E.]

Hey, Paul,

Instead of Comments, sometimes I use the Input Message of Data Validation.
This way, the 'Comment' shows up only when the cell is selected.

There are two ways to control if the user sees the 'comment', also. First,
you can lock the cell
Range("A1").Locked = True
so the user can't get there to see it. (of course, the workbook must be
protected)

Second, you can set the validation to display (or not display) the Input
Message
Range("A1").Validation.ShowInput = True (False)

 

[Paul]

Thanks Brad!

Although the message area is too limited for some comments this is very
helpful!
This is just what I need. Thanks again.