Hi

I'm trying to ensure appointments on our calendar are colour-coded by
keywords. To keep track of which colour is assigned to which keyword,
and so I can show others, I'm using Excel 2007. The problem is, I
can't find anywhere that lists the rgb / hex value of the named
colours (red, dark red, teal, maroon, etc).

Please does anyone know where I can find these values, or better
still, just let me know what they are?

Thanks in advance

Steve

Years ago I had a tool that displayed the value for the color of where the
mouse cursor was placed over. But I don't remember its name.

Why don't you just use the indices of the colors? The figures are fixed, it
isn't possible to change the color. For instance, 15 is the value of the
black category.

You can see all the values in the object browser: Open the VBA editor, press
f2, then select OlCategoryColor left hand.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
http://www.vboffice.net/product.html?pub=6&lang=en


Am Tue, 12 Jan 2010 08:36:50 -0800 (PST) schrieb Crankylemming:

Hi

I'm trying to ensure appointments on our calendar are colour-coded by
keywords. To keep track of which colour is assigned to which keyword,
and so I can show others, I'm using Excel 2007. The problem is, I
can't find anywhere that lists the rgb / hex value of the named
colours (red, dark red, teal, maroon, etc).

Please does anyone know where I can find these values, or better
still, just let me know what they are?

Thanks in advance

Steve