Using VBA detect color of Font

[Gary]

I have a problem with some folks who have colored various tasks red, blue,
green, etc. to mean something special . It is difficult for me to find all
of their changes based on color alone.

I have NOT found a way using VBA to test for color in MS Project. I see
how to set a font color. I am wondering if there is a way using a GDI
library to write a routine that would return a font color ? Somehow you pass
the task object (task name, task.Unique ID, etc. ) to a routine and it
returns the font color.

There has to be a way because when you highlight a task object, you can get
the font proprieties.

Thanks for your help,

Gary

 

[Jan De Messemaeker]

Hi,

Can you?
AFAIK all the font attributes are "write only".
Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[John]

I have a problem with some folks who have colored various tasks red, blue,
green, etc. to mean something special . It is difficult for me to find all
of their changes based on color alone.

I have NOT found a way using VBA to test for color in MS Project. I see
how to set a font color. I am wondering if there is a way using a GDI
library to write a routine that would return a font color ? Somehow you pass
the task object (task name, task.Unique ID, etc. ) to a routine and it
returns the font color.

There has to be a way because when you highlight a task object, you can get
the font proprieties.

Thanks for your help,

Gary

Gary,
I don't know about the GDI you refer to but as Jan said, font
characteristics in Project are write only.

In cases like this you can use an indirect approach. Unless your users
use a totally random color scheme, find out what criteria they use to
set the colors. Then write VBA code or possibly even a filter to check
that criteria and isolate the tasks of interest.

John
Project MVP

 

[Dytham]

I don't know of any helpful answer either, but just to add a further
complication:

Surely font colour is also a function of the View in use ?

A cell given a font colour in Gantt View will not have that colour in
Tracking Gantt View.