Excel comments (Office 2000)

Topic

New Reply

When I insert a comment in Excel, the type font in the comment box defaults to 8-point and bold. Is it possible to change that default to 12 point and not bold?

Reply | Quote

Replies

Hmmm. Usually only the first line of an Excel cell comment is bold, by default. That line indicates who the user is and pulls the name from the Tools>Options>General>User field. Other lines are normally not bold.

There is no feature, that I’m aware of in any version to change the DEFAULT of the comment formatting, although you can change each comment individually.

Outside of Excel, you can change Windows Tool Tip appearance, which will then change the default for the comments boxes. But, be aware, this also changes other elements in all programs as you will see.

To change the Tool Tip appearance, get into the dispaly properties in the Control Panel. Change the appearance of the Tool Tip element. You’ll see comments defaults change when you return to Excel and insert a comment. But rest your mouse on a tool and watch how different that tool tip is also.

I guess you can change the defaults for when working in Excel and then change them back when you are done. The formatting in the comments will hold.

-Lenny

Reply | Quote

As Lenny suggested there is no way to set the comment font defaults in Excel itself, as the tool tips settings for windows are used. To avoid having to set and reset you Windows settings, you could run the following code when your comments are in place. It should set the font properties to suit your requirements for all the comments on the active worksheet.

Sub SetCommentFont()
Dim oCell As Range
    For Each oCell In Cells.SpecialCells(xlCellTypeComments)
        With oCell.Comment.Shape.TextFrame.Characters.Font
            .Size = 12
            .Bold = False
        End With
    Next
End Sub

Andrew C

Reply | Quote

The caveat to the last post is:
If you have comments that you purposely made larger or smaller or bolded, you will lose that when the macro is run.
Steve

Reply | Quote