Change default format for comments

[Tati Howell G2 Architects]

Is it possible to change the default text formatting for comments (e.g.
from Geneva Bold 9pt tp Geneva Regular 12pt)? And to not have the
comments start with the user name? We are using Excel X for Mac on
OS 10.2 (and 10.3, on a network, if that makes a difference...)

Any help appreciated! Tati

 

[Bill]

I am very interested in this as well. Maybe someone with more time
and/or more knowledge than me can offer some assistance. Recording a
visual basic script does not record font properties. I have a VB
script add comments, and these are the properties I've been able to
work with so far:

With Cells(thisRow + firstRow - 1, theCol)
.ClearComments 'Need to ClearComments in case one already exists
.AddComment
.Comment.Visible = False
.Comment.Text Text:=thisText
.Comment.Shape.TextFrame.WrapAutoText = False
.Comment.Shape.TextFrame.AutoSize = True
End With