Comments in Excel 1

[SimonDavis]

Anybody know how to change the default format of comments in cells?

The default on mine is 8 point Tahoma, which on 1024 x 760 looks like a squashed ant.

Thanks

 

[riatsila]

Highlite the comment, and go to the format option and choose your font. ASD...

 

[riatsila]

Sorry, go to tools and options and change the default to whatever font you want, this will affect all fonts I believe. ASD...

 

[SimonDavis]

Unfortunately that doesn't work. The default font applies to just about everything except the comments. I've been trying to solve this for a while actually.

I know I can change them manually after I've inserted them, but it's a bit tedious when there are a lot of them.

Anyway, thanks for the ideas!

 

[MJPPaba]

try this...

Sub ChangeCommentFont()
Dim myCmt As Comment, i As Integer

For Each myCcmt In ActiveSheet.Comments
With myCmt.Shape.TextFrame.Characters.Font
.Name = "Arial"
.Size = 16
.Bold = False
End With
Next
End Sub


change the font name sizes and other characteristics to refine your styling. probably not much use anymore but what the heck.

cheers

Matthew

The only bad question is the question you dont ask!