LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ai18ma
 
Posts: n/a
Default Changin the color of the comment indicator and back!

Hi,

Thanks to the postings here, I was referred to an Excel treasure trove
www.contexture.com. I found a workaround for changing the color of the
Comment Indicator from red to anything else. Few Questions remain though:
1. It seems 80 is the highest color-value it takes (Excel 2002, SP3). Above
80, I a get error message. Is that so?
2. Is there a color-table somewhere I could use to see the available colors,
instead of trial and error in guessing the color?
3. The shape around the indicator remains after the comment is deleted. What
is the code to delete the shape afterwards? Something like:
If (comment == deleted) {
Shape.delete;
}

or alike. Many thanks again.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"