Expanding Tasks

[Steve Scott]

I have about 20 or so sub-project plans feeding into an Integrated plan. Each
plan has varying degrees of Outline Levelling. The problem is when I open
the Integrated Plan and click Show all tasks or Show to Level 9, it does not
expand all sub tasks. This means I am having to scroll down through a plan of
several 1000 lines to ensure every level of nesting is expanded - this is
taking ages! Is there any macro I can set up that will do a Global Select
all rows and expand the lot in one go??

Thanks In Advance

 

[John]

I have about 20 or so sub-project plans feeding into an Integrated plan. Each
plan has varying degrees of Outline Levelling. The problem is when I open
the Integrated Plan and click Show all tasks or Show to Level 9, it does not
expand all sub tasks. This means I am having to scroll down through a plan of
several 1000 lines to ensure every level of nesting is expanded - this is
taking ages! Is there any macro I can set up that will do a Global Select
all rows and expand the lot in one go??

Thanks In Advance

Steve,
Yes, use the following Method.
OutlineShowTasks expandinsertedprojects:=True

Hope this helps.
John
Project MVP

 

[JackD]

You can also click on that button a dozen times or so. It is faster than
scrolling.

 

[Steve Scott]

Thanks John, this has worked great - a massive time saver!

 

[John]

Thanks John, this has worked great - a massive time saver!

Steve,
You're welcome. When I first ran into the problem a few years ago it
took a lot of searching the VBA help to find that little gem.

John