Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

How to Hide Comment Indicators and have Comments Still Appear

Posted by David Holstein on October 21, 1999 6:12 AM
Is there a way to hide those ghastly red comment indicators and still have the comments appear when the cell is selected. I don't want to use the option of Show Comment permanently.

Thanks in advance!

David


Re: How to Hide Comment Indicators and have Comments Still Appear

Posted by Jamie on October 21, 1999 8:35 AM

As far as I know you always get indicators but if you use data validation instead you can put a comment that appears when the mouse is over the cell, which in effect gives you what you want


Re: How to Hide Comment Indicators and have Comments Still Appear

Posted by Ivan Moala on October 21, 1999 1:44 PM

I'm not sure that you can, but as a work around
you could use the data / validation / input message.
The draw back been that it will not show unless you are in the activecell & you can't change background colours fonts etc.


Ivan


Re: How to Hide Comment Indicators and have Comments Still Appear

Posted by Denise on December 15, 1999 10:15 AM
Hi David,

I have a great way to hide the stupid (but useful) red flags.
Let's say you have added all the comments you want and are now
ready to send off your file but don't want those red flags
around. Go to Tools, Options, View and then find "comments"
(send down) and select "none". This will hide those red flags and no one
will know it's there but you. When you need to find them again
go back to tools and then choose "comment indicator only" to
locate those flags for you.

Good luck!
Denise


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.