Solved

MSProject VBA: Hide subtasks without hiding lower level summaries

Posted on 2014-03-01
4
1,108 Views
Last Modified: 2014-03-01
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.
0
Comment
Question by:dgmoore1
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:regmigrant
ID: 39897338
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
0
 

Author Comment

by:dgmoore1
ID: 39897378
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.
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39897393
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
0
 

Author Closing Comment

by:dgmoore1
ID: 39897478
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.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question