Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Formatting comment boxes (Excel 2003)

    I have a question about comment boxes...I have a wbook that will be used by numerous employees....to assist them, I have added comment boxes that appear when you hover over the cell. I have formatted them (using RT-CLICK & Properties)....will the formatting appear in everyone's copy or is the formatting used-defined...?...and will the comment boxes appear in their default format (which will make them almost useless)? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting comment boxes (Excel 2003)

    The comment boxes should retain the formatting you applied - this is stored with the workbook.

    But whether the comments will be displayed is a user-level setting: in the View tab of Tools | Options... one can choose between
    None - comments are hidden
    Comment indicator only - the comment is shown when the mouse pointer is over the cell
    Comment and indicator - comments are always visible

  3. #3
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Formatting comment boxes (Excel 2003)

    Thank you for that Hans....I thought I had seen a post from you in the Daily Index (about 2 weeks ago) saying that the format was user-specific but you have cleared it up...I was aware of the Tools|Options settings but I will not tell people about 'turning this on' in my Instructions...thanks again

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting comment boxes (Excel 2003)

    The default formatting of comments is user-specific (it depends on the settings for Tooltips in Windows). So if you create a comment and leave its formatting unchanged, the comment will take on the user's Tooltip formatting. But if you change the font or background color, this will be stored with the workbook, so that all users will see the same font or background color.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting comment boxes (Excel 2003)

    <hr>I will not tell people about 'turning this on' in my Instructions.<hr>
    Hans can correct me if I am wrong, but if you are going to the trouble of formatting the comment boxes you should tell your users to make sure they do not have comments turned off (set to None) or they will neither see them nor know that they are there.

    Paul

  6. #6
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting comment boxes (Excel 2003)

    Hans, where do you change the tooltip format in Windows?
    Thanks,

    itconc

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting comment boxes (Excel 2003)

    These instructions are for Windows XP. No doubt it's different in Vista.

    Right-click an empty part of the desktop.
    Select Properties from the popup menu.
    Activate the Appearance tab.
    Click Advanced.
    Select Tooltip from the Item dropdown.
    You can specify the font and background properties for tooltips here.
    Make sure that you click OK if you have changed the settings, don't just close the dialogs.

  8. #8
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting comment boxes (Excel 2003)

    Thanks Hans! It works like a charm - I needed it for comments in Excel.

Posting Permissions

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