comment & indicator

sandy · Mar 7th, 2002, 11:47 AM

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 · Mar 7th, 2002, 12:01 PM

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 · Mar 7th, 2002, 01:22 PM

Thank you!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 11:47 AM	#1
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	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...!

Mar 7th, 2002, 12:01 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 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 ]

Mar 7th, 2002, 01:22 PM	#3
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	Thank you!