Changing default fonts and color for comments that are tied to a cell

[Ed]

Is there a way to change the default font and color for
comments. I know how to change it manually each time I
add a comment but would like to permanently change the
default. Currently it is Tacoma 8. Thanks, Ed.

 

[pfsardella]

John Walkenbach has a spiel on this.

http://www.j-walk.com/ss/excel/usertips/tip075.htm

HTH
Paul

 

[Debra Dalgleish]

You can change the font size and colour of new comments (but not the
font) by changing the settings in your Control Panel. (Instructions for
Windows XP)

1. Right-click on the desktop, and choose Properties
2. On the Appearance tab, click Advanced.
3. From the Item dropdown, choose Tooltip
4. Choose a font Size, click OK, click OK

Note -- this will also affect your Tooltips formatting

Or, you can use a macro to insert a comment with a specific font and format:

Sub CommentAddOrEditTNR()
'adds TimesNewRoman comment or positions
'cursor at end of existing comment text
Dim cmt As Comment
Set cmt = ActiveCell.Comment
If cmt Is Nothing Then
ActiveCell.AddComment text:=""
Set cmt = ActiveCell.Comment
With cmt.Shape.TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 11
.Bold = False
.ColorIndex = 0
End With
End If
SendKeys "%ie~"
End Sub