Results 1 to 2 of 2
Thread: Comment Boxes (Excel 2000)
2005-09-24, 14:26 #1
- Join Date
- Mar 2001
- Pa, Pennsylvania, USA
- 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.
2005-09-24, 14:53 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- 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)