View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Excel 2003 - setting the Comment font size default

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

"rickz" wrote in message
...
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