MS Project color rolled up taskbar

F
Forum Guest 👤 Member for 17 years 6 months
R
Renaud Moisan 👤 Member for 20 years 8 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 6 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)

Featured Partner

Top Posters

jeoffrey reyes
15 posts
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts