How do I change default font for all new comments in Office 2003?

[Guest]

I just installed Office 2003 and transfered excel files from the older
version. The comments that I had created before I moved to 2003 look fine in
the default font (Tahoma); however, when I try to insert a new comment, the
same font (same size, same formatting) the text looks virtually unreadable. I
changed font in some comments and they look much better, but it is extremely
inefficient to try to change font in every new comment I insert, so I thought
maybe there is a way to do it on a default basis. Or maybe I somehow could
change something to make Tahoma appear readable. Please, assist.

 

[Jim Rech]

We have no control over the default font Excel uses with new comments. I
saw no difference in the way the Tahoma font in comments looked in Excel
2003 versus earlier versions. Pretty weird.

You can change comment fonts en masse with a macro though...

Sub ChgAllCommentFonts()
Dim Cell As Range
For Each Cell In Cells.SpecialCells(xlCellTypeComments)
With Cell.Comment.Shape.TextFrame.Characters.Font
.Name = "Terminal"
.Size = 9
End With
Next
End Sub

--
Jim
|I just installed Office 2003 and transfered excel files from the older
| version. The comments that I had created before I moved to 2003 look fine
in
| the default font (Tahoma); however, when I try to insert a new comment,
the
| same font (same size, same formatting) the text looks virtually
unreadable. I
| changed font in some comments and they look much better, but it is
extremely
| inefficient to try to change font in every new comment I insert, so I
thought
| maybe there is a way to do it on a default basis. Or maybe I somehow could
| change something to make Tahoma appear readable. Please, assist.