Excel 2003 - setting the Comment font size default

R

rickz

Anyone know how to set the default so it applies to all comments - mine is
set at 8 point much too small, and I can only change within each comment one
at a time. Thanks
 
N

NickHK

I don't see any way to affect the default behaviour, but you can change all
comments in a WB with:

Dim WS As Worksheet
Dim Com As Comment

For Each WS In ThisWorkbook.Worksheets
For Each Com In WS.Comments
With Com.Shape.TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 14
End With
Next
Next

NickHK
 
H

hmm

You change the default comment properties through the ToolTips in Windows.
Right click on the desktop, select Properties, choose the Appearance tab then
Advanced. Under Item, select ToolTip. From here you can change the default
background color and font for Excel comments.
 
N

NickHK

OK, I stand corrected. But this will change all such objects in Windows, not
just Excel comments.

NickHK
 
Top