View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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.