format for comments

[Guest]

I want to find out how to change the default format for comments, cause I
hate having to right-click/format every time.
tks for all
De

 

[Jim Rech]

There is no way to change Excel's comment default font. A workaround is to
use a macro to create a new comment, for example:

Sub NewComment()
On Error Resume Next
With ActiveCell.AddComment.Shape
.TextFrame.Characters.Font.Name = "Terminal"
.TextFrame.Characters.Font.Size = 9
.ScaleWidth 1.5, msoFalse
.ScaleHeight 1.5, msoFalse
.Visible = msoTrue
.Select
End With
End Sub


--
Jim
|I want to find out how to change the default format for comments, cause I
| hate having to right-click/format every time.
| tks for all
| De
|

 

[Guest]

Jim, you're awesome!!!! I've been trying to figure out how to change the
comment font size. Thanks for posting this work-around!