change font color of tasks or color of bars from VBA

[Werner Koch]

Hi!

How is it possible to change the fontcolor of a task or the color of a bar
from vba?

thx

 

[Jan De Messemaeker]

Hi Werner,

Font: look up Application.Font for individual cells
It works on the active selection

Text Styles: Look up application.textstyles
It works on the Active view

Individual Gantt Bars:
Look up Application.GanttBarFormat
Works on selected tasks or on a given ID

Bar Styles:
Look up application.GanttBarStyleEdit

HTH

 

[JackD]

I have some sample code for turning all the bars green at my website.
http://masamiki.com/macros.htm look for the all green macro.
There are methods for changing font color too (see John's message).
The one thing that can't be done is to change the cell background color.