Just in case there is an interest, the free Excel add-in
"Determine Colors" provides a listing of the colors used in the cell
by right-clicking it - background, borders, font, pattern (and sheet tab).
May be of greatest usefulness to color blind Excel users. Download from ...
http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


wrote in message ups.com...
hi

I've used the ColorIndex Property to manage colors in my spreadsheets
before. So activecell.Interior.colorindex = 5 will shade the activecell
with certain shade of Blue.

Is there anyway to access the NAME associated with the color? I can see
the name when I used the color pallete - you select a color, keep your
mouse over it, and in a second or so, it gives you a label. How does
one access that label/name using VBA?
thanks
s