Thanks Brad!

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

"Brad E." wrote:

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)
--
HTH, Brad E.


"Paul" wrote:

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.