David McRitchie has lots of info about colors:
http://www.mvps.org/dmcritchie/excel/colors.htm
And if you want to delete the righttriangle if the cell doesn't contain a
comment:
Option Explicit
Sub testme()
Dim myShape As Shape
Dim wks As Worksheet
Set wks = Worksheets("Sheet1")
For Each myShape In wks.Shapes
If myShape.AutoShapeType = msoShapeRightTriangle Then
If myShape.TopLeftCell.Comment Is Nothing Then
myShape.Delete
End If
End If
Next myShape
End Sub
ai18ma wrote:
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.
--
Dave Peterson