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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word to Excel: Export comments with text and line number 0
Disable AutoComplete with VB Code for a Single Workbook 6
With Specific App 2
Code to add comments to selected cells within a selected range 30
Copy the contents of a range of cells to a single comment(indicator)? 2
Excel Import Comments 3
Copying a Picture From Cell Comment 0
Show Excel comment on mouseover but not the comment indicator 7

Back
Top