Gantt bars color VBA

[cicaesar]

Hi all,

I've written a VBA macro to color my Gantt bars basing on thei
advancement; problem is I can only choose the color between the 1
pjColor array defaults, and the pjYellow is pretty much invisible on
white background.

Is there a way to change the pjColor defaults, or to add colors (throug
the RGB function maybe)?


Thanks in advance for your help

Edit: I'm using Microsoft Project 200

 

[Mike Glen]

Hi cicaesar,

Try posting on the microsoft.public.developer newsgroup (forum). Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP



Hi all,

I've written a VBA macro to color my Gantt bars basing on their
advancement; problem is I can only choose the color between the 16
pjColor array defaults, and the pjYellow is pretty much invisible on a
white background.

Is there a way to change the pjColor defaults, or to add colors (through
the RGB function maybe)?


Thanks in advance for your help

Edit: I'm using Microsoft Project 2003

 

[Andrew Lavinsky]

Just note that nowhere in the 2007 product is the oppportunity to use any but
those predefined colors.

That's one of the improvements in 2010, that now you can choose from the
full range of colors.

You may want to think about combinations of colors - using two bars, one on
top and one bottom.