Using VBA, I am looking for a way to copy a bar attribute (color, style, ...) to another bar.
Searching the web I found how to assign a format to a bar using ganttbarformat. But I cannot find a way to get the format values of a given bar... Anybody can help?
Member for
20 yearsRE: MS Project color rolled up taskbar
Sorry for unearthing this topic :)
Using VBA, I am looking for a way to copy a bar attribute (color, style, ...) to another bar.
Searching the web I found how to assign a format to a bar using ganttbarformat. But I cannot find a way to get the format values of a given bar... Anybody can help?
Member for
16 years 9 monthsRE: MS Project color rolled up taskbar
(solution provided by Gérard Ducouret)
Refer to the subtask with this code:
GanttBarFormat TaskId:=x,GanttStyle:=y, MiddleColor:=z
x=TaskID
y=style number of the rolled up bar (see bar styles: default = 5)
z=predefined color (e.g. pjGreen)