burlsyboy
11-18-2011, 08:13 AM
Hi Gurus,
My VBA is fairly good but I am new to MS Project.
I am writing a routine to loop through tasks and format the Gantt bars depending on their type.
Once formatting is done I roll-up the Gantt tasks to summary.
rTask.Rollup = True
When project rolls-up the tasks it looses the formatting on the summary Gantt. My question, how do I access the rolled-up tasks to format in VBA?
On the UI you just select and repeat the original formatting. I have tried recording this action in a macro but the code just formats the unrolled-up task.
Any guidance gratefully recieved. :dunno
My VBA is fairly good but I am new to MS Project.
I am writing a routine to loop through tasks and format the Gantt bars depending on their type.
Once formatting is done I roll-up the Gantt tasks to summary.
rTask.Rollup = True
When project rolls-up the tasks it looses the formatting on the summary Gantt. My question, how do I access the rolled-up tasks to format in VBA?
On the UI you just select and repeat the original formatting. I have tried recording this action in a macro but the code just formats the unrolled-up task.
Any guidance gratefully recieved. :dunno