Change default format for comments

External Since: Apr 02, 2004 Posts: 1

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

External Since: Feb 11, 2004 Posts: 6

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

"Tati Howell G2 Architects" wrote in message ...
> 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