Comments in Excel

[swamit]

How can I change the DEFAULT for the font and font size for the comments that can be inserted in Excel cells. ???

 

[jebry]

Hi!

Open the comment and select the text. Right click and choose format comment.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[swamit]

Hey Jeff,
Thanks for your response. But I am looking to change the DEFAULT on the comment font and size....so that I dont have to change it everytime....it defaults to font size 8 always....i want to make it default to 12...

 

[acron]

I think you need to alter some system wide settings. In control panel, appearance change the attributes for the Tooltips item to your requirements.

But this will have system wide implications.

AC

 

[SkipVought]

Hi swamit,

What you could do is format ALL your comments AFTER having entered them, (or anytime for that matter) using code like this...

Sub FormatComments()
    For Each Comment In ActiveSheet.Comments
        With Comment.Shape.DrawingObject
            With .Font
                .Name = "Arial"
                .Size = 10
                .Strikethrough = False
                .Superscript = False
                .Subscript = False
                .OutlineFont = False
                .Shadow = False
                .Underline = xlUnderlineStyleNone
                .ColorIndex = 46
            End With
        End With
    Next
End Sub

Hope this helps Skip,
metzgsk@voughtaircraft.com