How to read the color of a ganttbar within VBA RRS feed

  • Question

  • I need to read out the color of a ganttbar for a task. I can find the function to set the color (GanttBarFormat) but not to read it back. Who can help?

    Thanks in advance

    Friday, December 29, 2017 7:00 PM

All replies

  • I'm pretty sure that the GanttBar method is read only.

    A workaround is to set a Flag field and have the bar style change if Flag field is set. then you can detect which flag is set and change as required.

    Rod Gill
    Author of the one and only Project VBA Book and VBA developer.

    Sunday, December 31, 2017 11:04 PM