Where to stick macro to change default comment font?
 

I just did a search of this group to try to figure out how to change
the default comment font from bold to regular in Excel 97.

The consensus seemed to be that there is no way to change that setting
so a macro has to be used.

I don't have a clue what to do with a macro. I mean, where am I
supposed to stick it to make it work?

What I want is for the comment window to open with no author name and
no bold font.

Here's a suggested macro I found in this group:

Sub NewComment()
On Error GoTo HasComment
With ActiveCell
..AddComment.Visible = True
..Comment.Shape.Select
Selection.Font.Name = "Comic Sans MS"
Selection.Font.Size = 12
..Comment.Visible = False
End With
HasComment:
SendKeys "+{F2}"
End Sub

http://www.contextures.com/xlcomments03.html

or one level above:

http://www.contextures.com/xlcomments01.html

Debra Dalgleish's site

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I just did a search of this group to try to figure out how to change
the default comment font from bold to regular in Excel 97.

The consensus seemed to be that there is no way to change that setting
so a macro has to be used.

I don't have a clue what to do with a macro. I mean, where am I
supposed to stick it to make it work?

What I want is for the comment window to open with no author name and
no bold font.

Here's a suggested macro I found in this group:

Sub NewComment()
On Error GoTo HasComment
With ActiveCell
.AddComment.Visible = True
.Comment.Shape.Select
Selection.Font.Name = "Comic Sans MS"
Selection.Font.Size = 12
.Comment.Visible = False
End With
HasComment:
SendKeys "+{F2}"
End Sub