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

  • Thread starter Thread starter Ed
  • Start date Start date
E

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.
 
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
 
Back
Top