Conditionally Hiding Comment markers.
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.
"Paul" wrote in message
...
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.
|