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" wrote in message
...
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