MS Project color rolled up taskbar

F
Forum Guest 👤 Member for 17 years 5 months
R
Renaud Moisan 👤 Member for 20 years 7 months

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?

F
Forum Guest 👤 Member for 17 years 5 months

(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)

Forum Sponsor

Top Posters

Trian Asmoro
1 posts
Soheil Barekat
4 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts