Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Pa, Pennsylvania, USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comment Boxes (Excel 2000)

    <P ID="edit" class=small>(Edited by Leif on 24-Sep-05 16:26. to reduce attachment size and prevent horizontal scrolling.)</P>I like to use the Comment boxes in cells in Excel. Some time back, something happened to my comment box and when it comes up, it starts with a colon ([img]/forums/images/smilies/smile.gif[/img] and has about two lines spaced down. Each time I have to highlight the area and delete or paste from somewhere.
    I have searched and searched for the answer to this but have not found it.
    Does someone out there know how to fix this ? I have used the Windows settings to change colors if I need but there is nothing there to change the default when the box comes up.
    Thanks everyone

  2. #2
    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: Comment Boxes (Excel 2000)

    It sounds like you have removed your "username" [tools - options- general(tab)]

    Once you have a username entered you will get Username the colon and then the line. This is how comments work. If you do not want the username colon and next line, you can remove them after the fact with a macro. <post#=290,956>post 290,956</post#> has some code that may be adapted (it also Changes the font to BOLD, Arial size 12 and red and Changes the bkgrd of the box to white)

    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
  •