MSProject VBA: Hide subtasks without hiding lower level summaries

dgmoore1
dgmoore1 used Ask the Experts™
on
Is there a way to hide the subtasks of a summary (using OutlineHideSubtasks) without also rolling up all of the lower level sub-summaries? My user has a large schedule that is difficult to work with: if all of the child tasks of a given summary are completed he wants to roll them up (hide them) to reduce clutter.

I have given him a macro that achieves the effect visually using flags and a filter, but my user wants the displayed recordset to include, but hide, completed tasks so he can unroll them if needed. I told him it's easy enough to remove the filter to display all tasks, but that's not what he's looking for.

I don't know if this is possible, or if there is an alternative method to OutlineHideSubtasks - any suggestions would be appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I'm not sure I understand the question correctly; any summary task that has all its child tasks complete can be collapsed to hide the sub tasks, but will still be visible as 100 complete; if it is on the same level as some other summaries/tasks then it can't be hidden except by filtering

Author

Commented:
Like this:

Summary 1
  Task 1 100%
  Task 2 100%
  Task 3 100%
  Summary 1.1
    Task 1 100%
    Task 2 100%
    Task 3 100%
  Summary 1.2
    Task 1 50%
    Task 2 50%
    Task 3 50%

Roll up only Summary 1 and 1.1's tasks, so the display looks like this:

Summary 1
  Summary 1.1
  Summary 1.2
    Task 1 50%
    Task 2 50%
    Task 3 50%

OutlineHideSubtasks on Summary 1 will display just

Summary 1

Summary 1.1 and 1.2 get rolled up because they are children of summary 1.

If I use a filter I can get the display I want, but I can't expand Summary 1 or 1.1 independently to display their completed tasks.
to achieve
Summary 1
  Summary 1.1
  Summary 1.2
    Task 1 50%
    Task 2 50%
    Task 3 50%

you would need to have a 'summary 1.0' rolling up the non-summary tasks like so:-
Summary 1
  Summary 1.0
   Task 1 100%
   Task 2 100%
   Task 3 100%
  Summary 1.1
    Task 1 100%
    Task 2 100%
    Task 3 100%
...

There is no way to display a subset of tasks at a given outline level without additional filter (display the outline level column and you will see what I mean).

In 2013 you can add a custom outline code that could be assigned to the 100% and then a filter on that might get closer to what's needed

Author

Commented:
I agree  - they're using Project 2010, so 2013 features aren't available. Also, they are not going to restructure their outline - I need to work with it as-is. I'm going to continue to push for the filter solution, which works fine. If they need to expand the outline they can just remove the filter; if they want to roll it back up they can run the macro and apply the filter.

Thanks for your comments.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial