Removing the : in the coment field
 

When I insert a comment to a field a colon appears. I know this is meant for
the user name to appear but I don't want that. In fact, I don't want the
colon to appear. Currently I manually delete it from each comment I
insert...is there a way to turn that feature off so I merely type in text
without having that colon appear?...I am using Excel 2000

Thanks!
Kathy

You can use programming to insert comments with no user name. There is
sample code he

http://www.contextures.com/xlcomments03.html


Kathy wrote:
When I insert a comment to a field a colon appears. I know this is meant for
the user name to appear but I don't want that. In fact, I don't want the
colon to appear. Currently I manually delete it from each comment I
insert...is there a way to turn that feature off so I merely type in text
without having that colon appear?...I am using Excel 2000

Thanks!
Kathy



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html