Gantt bars color VBA
in [Project]
|
From: cicaesar on 29 Apr 2010 04:30 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 -- cicaesar ------------------------------------------------------------------------ cicaesar's Profile: http://forums.techarena.in/members/214531.htm View this thread: http://forums.techarena.in/microsoft-project/1332425.htm http://forums.techarena.in
From: Mike Glen on 29 Apr 2010 07:29 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 "cicaesar" <cicaesar.4a69lb(a)DoNotSpam.com> wrote in message news:cicaesar.4a69lb(a)DoNotSpam.com... 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 -- cicaesar ------------------------------------------------------------------------ cicaesar's Profile: http://forums.techarena.in/members/214531.htm View this thread: http://forums.techarena.in/microsoft-project/1332425.htm http://forums.techarena.in
From: Andrew Lavinsky on 29 Apr 2010 11:32 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. "Mike Glen" wrote: > 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 > > > "cicaesar" <cicaesar.4a69lb(a)DoNotSpam.com> wrote in message > news:cicaesar.4a69lb(a)DoNotSpam.com... > > 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 > > > -- > cicaesar > ------------------------------------------------------------------------ > cicaesar's Profile: http://forums.techarena.in/members/214531.htm > View this thread: > http://forums.techarena.in/microsoft-project/1332425.htm > > http://forums.techarena.in >
|
Pages: 1 Prev: Display Baseline Start Finish Dates on My Tasks Page Next: RESOURCE USAGE |