Turn on Comment Indicator Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way in VBA to turn on the Comment Indicator Only option in Tools:Options. I need to make sure that this option is selected when any user opens the document. Also, if I can do this in VBA, do I need to put this in the workbook code? Thanks. Matt
 
Place this in the workbook code module, this runs only when the workbook is
first opened.

Private Sub Workbook_Open()
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End Sub

--
Regards,
Rocky McKinley


Matt said:
Is there a way in VBA to turn on the Comment Indicator Only option in
Click to expand...
Tools:Options. I need to make sure that this option is selected when any
user opens the document. Also, if I can do this in VBA, do I need to put
this in the workbook code? Thanks. Matt
 
Back
Top