-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
comment & indicator
- Thread starter sandy
- Start date
lenze
Legend
- Joined
- Feb 18, 2002
- Messages
- 13,690
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
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
Upvote
0
