A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Calendar
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Colour values of calendar categories



 
 
Thread Tools Display Modes
  #1  
Old January 12th, 2010, 04:36 PM posted to microsoft.public.outlook.calendaring
Crankylemming
external usenet poster
 
Posts: 5
Default Colour values of calendar categories

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
  #2  
Old January 12th, 2010, 05:24 PM posted to microsoft.public.outlook.calendaring
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,346
Default Colour values of calendar categories



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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.