Thread: Comment size
View Single Post
  #1   Report Post  
Don
 
Posts: n/a
Default Comment size

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.