Comment size

[Don]

I'd like to change the comment size in excel, but do not want to use the
Properties - Appearance - Advanced - Item - Tooltip route.

I've seen this on Debra Dalgleish's site -
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

Can I put this in some kind of excel startup file so that all Excel files
that I create or edit will have these new comment settings? Thanks for any
comments.

 

[Debra Dalgleish]

You could add the macro to your Personal.xls workbook, or another file
that you usually have open. Then, add a button to one of your toolbars,
and assign that macro to it.

When you want to insert a comment, click the toolbar button.