Changing default Comments settings

Question

When a Comment is inserted in a cell, its default position setting is "Don't move or size with cell".  Is it possible to change this to Move and size with cell so that future comments will default that setting?

There does not seem to be anything about this in Options>Advanced and the only way to change this is to right click each comment and select the correct button on Properties tab.

Answer 1

Hi,

you can set your comment options with VBA:

Sub AddComment()

  With ActiveCell

    .AddComment

    .Comment.Visible = False

    .Comment.Text Text:="Frank Arendt-Theilen:" & Chr(10) & ""

    .Comment.Shape.Placement = xlMoveAndSize

  End With

End Sub

Regards,

Frank

---

If this post answers your question, please mark it for all readers as the Answeror vote if the reply has been helpful.

Answer 2

I'm not familiar with VBA. 2 Questions. 1) how do I set this up in VBA. 2) I notice this is an older post. Is there now a way of setting the default for all comments in a workbook?