comment & indicator

[sandy]

Hello! I know you can change the comments from showing or not showing by going through options. Is there anyway to limit that function just on certain sheets... not just the entire workbook? Thanks in advance...!

 

[lenze]

You can use the WorkSheet Activate Event to control the display.

In the module for each sheet you want to hide comments enter this code.

Private Sub Worksheet_Activate()

Application.DisplayCommentIndicator=0

End Sub

Enter the same on sheets where you want to see the comments, changing the 0 to a 1
This message was edited by lenze on 2002-03-07 11:03

 

[sandy]

Thank you!