Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MSProject VBA: Hide subtasks without hiding lower level summaries

Posted on 2014-03-01
4
Medium Priority
?
1,243 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

597 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