Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Brighton, Michigan, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comment formatting

    Is it possible to set a default format for cell comments? (I'm sure it must be possible, I just haven't found it). Currently, the comments are formatted in Tahoma 8-point, with my user name in bold.

    I'm running Excel 97 SR-2 on a Pentium III machine with Windows 2000 Professional OS.


    Thanks in advance,

    Randy

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment formatting

    I do not know of any way to change the default format of comments.
    Legare Coleman

  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: Comment formatting

    You can change the formatting of the comment box, but must do it by way of Display Properties in the control panel as it is based on a windows setting. If you select the Appearance tab from the Display Properties dialog, and then select Tooltip from the the Item dropdown list and set whatever formatting you wish for that, and it will apply to all new comments in Excel afterwards.

    But just be aware that it changes the tooltip display right across all windows applications, so you might want to be selective in your formatting.

    Andrew C

  4. #4
    Star Lounger
    Join Date
    Jun 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment formatting

    I'm using Excel97 with WindowsNT 4.0. I changed the font, size and color from Control Panel, Appearance, Tooltip. While all the formatting was applied to the tooltips, only the color and font size were applied to Excel comments.

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment formatting

    Work Around:
    I get around having to format each time, by copying the cell containing a formatted comment and using Paste | Special | Comments.
    I have added a Paste Comments button to my toolbar.


    Ruth

  6. #6
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment formatting

    How did you add a Paste Comments button to the toolbar?

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment formatting

    What I really use is a Paste Special button. From Tools Customise (or View Toolbars Customise) go to the Commands tab and down to the Edit category. On the right hand side, from the list of edit commands, choose PasteSpecial... and drag it onto the toolbar (next to the Paste icon perhaps).
    Then I clicked on the Paste Formatting button (or the Paste Values button) which I had already on the toolbar, and chose Modify Selection and CopyButtonImage. Then click on the PasteSpecial button and from ModifySelection choose Paste Button Image, then Edit Button Image and delete inside of the clipboard and put in S. Also change in Modify Selection to show Default Style (or ImageAndText, or as you want).
    If you want it to be PasteComments only, then you have to create a macro to do the paste comments actions and use the AssignMacro in ModifySelection.
    Do you need such a macro?
    Ruth

  8. #8
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment formatting

    Thanks, Ruth. I ended up using a macro, but I appreciate your explanation.

Posting Permissions

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