View Single Post
  #2  
Old April 1st, 2005, 09:30 PM
Jim Rech
external usenet poster
 
Posts: n/a
Default

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
"Elena" wrote in message
...
|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.