Comment size

D

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top