Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    Westlake, Ohio, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel comments (Office 2000)

    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?
    ...

  2. #2
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel comments (Office 2000)

    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

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel comments (Office 2000)

    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. <pre>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</pre>

    Andrew C

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel comments (Office 2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •