Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |