Conditionally Hiding Comment markers.

P

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.
 
J

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.
 
P

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?
 
B

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)
 
P

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.
 

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

Top