ID: Q97850
The information in this article applies to:
In Microsoft Project, you cannot create a filter that will automatically display the related subordinate tasks of summary tasks that meet the filter criteria. However, you can create a custom macro to achieve a result similar to what this type of filter would produce.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft Support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact the Microsoft fee-based consulting line at (800) 936-5200. For more information about the support options available from Microsoft, please see the following page on the World Wide Web:
http://www.microsoft.com/support/supportnet/refguide/default.asp
1. On the Project menu, point to Filtered For, and then click More
Filters.
2. Click New.
3. In the Name box, type "In-Progress Summaries" (without the quotation
marks). Set up the filter with the following information:
And/Or Field Name Test Value(s)
-----------------------------------------------------
Summary equals Yes
And Actual Start does not equal NA
And % Complete is less than 100%
4. Click OK. Click Close.
5. On the Tools menu, point to Macro, and then click Macros.
6. In the Macro Name box, type "In_Progress_Summary_Groups" (without the
quotation marks). Click Create.
7. Type the macro exactly as it appears below:
Sub In_Progress_Summary_Groups()
ViewApply Name:="Gantt Chart"
FilterApply Name:="In-Progress Summaries"
SelectColumn
OutlineHideSubtasks
OutlineShowAllTasks
End Sub
8. On the File menu, click Close and Return to Microsoft Project.
9. On the Tools menu, point to Macro, and then click Macros.
NOTE: Any task filter may be substituted for the "In-Progress Summaries" filter.
Running the above macro will automatically display the Gantt Chart view, filter Summary tasks that are in progress, and then expand all the subordinate tasks for the Summary tasks that are displayed.
If you do not want to create a macro, you can use the following alternative:
1. Apply the task filter.
2. Click a column in the table.
3. On the Project menu, point to Outline, and then click Hide Subtasks.
In Microsoft Project for Windows, you can also press ALT+SHIFT+HYPHEN.
In Microsoft Project for Windows, you can also press ALT+SHIFT+*
(asterisk on the numeric keypad).
1. On the Tools menu, point to Filtered For, and then click More Filters.
2. Click New.
3. In the Name box, type "In-Progress Summaries" (without the quotation
marks). Set up the filter with the following information:
Field Name Test Value(s) And/Or
---------------------------------------------------
Summary Equals Yes And
Actual Start Not Equals NA And
% Complete Less 100%
4. Click OK. Click Close.
5. On the Tools menu, click Macros.
6. Click New
7. In the Macro name box, type "In_Progress_Summary_Groups" (without the
quotation marks). Click OK.
8. Type the macro exactly as it appears below:
Sub In_Progress_Summary_Groups()
ViewApply Name:="Gantt Chart"
FilterApply Name:="In-Progress Summaries"
SelectColumn
OutlineHideSubtasks
OutlineShowAllTasks
End Sub
9. On the Tools menu, click Macros.
NOTE: Any task filter may be substituted for the "In-Progress Summaries" filter.
Running the above macro will automatically display the Gantt Chart view, filter Summary tasks that are in progress, and then expand all the subordinate tasks for the Summary tasks that are displayed.
If you do not want to create a macro, you can use the following alternative:
1. Apply the task filter.
2. Click a column in the table.
3. On the Project menu, point to Outlining, and then click Hide Subtasks.
In Microsoft Project for Windows, you can also press ALT+SHIFT+HYPHEN.
In Microsoft Project for Windows, you can also press ALT+SHIFT+*
(asterisk on the numeric keypad).
In Microsoft Project for the Macintosh, you can press COMMAND+OPTION+*
(asterisk on the numeric keypad).
1. On the Filter menu, click Define Filters.
2. Click New.
3. In the Name box, type "In-Progress Summaries" (without the quotation
marks). Set up the filter with the following definition:
Field Name Test Value(s) Op
---------------------------------------------------------
Summary Equals Yes And
Actual Start Not Equals NA And
% Complete Less 100
5. On the Macro menu, clcik Define Macros.
6. In the Macro Name box, type "In-Progress Summary Groups" (without the
quotation marks).
View .Name=[Gantt Chart]
Filter .Name=[In-Progress Summaries]
SelectColumn
OutlineCollapse
OutlineExpandAll
9. To run the macro, click Set.
NOTE: Any task filter may be substituted for the "In-Progress Summaries" filter.
Running the above macro will automatically display the Gantt Chart view, filter Summary tasks that are in progress, and then expand all the subordinate tasks for the Summary tasks that are displayed.
If you do not want to create a macro, you can use the following alternative:
1. Apply the task filter.
2. Select a column in the table.
3. Click Collapse.
In Microsoft Project for Windows, you can also press ALT+SHIFT+-
(minus sign on the numeric keypad, NUM LOCK off).
In Microsoft Project for Macintosh, you can press COMMAND+OPTIONS+-
(minus sign on the numeric keypad, NUM LOCK off).
In Microsoft Project for Windows, you can also press ALT+SHIFT+*
(asterisk on the numeric keypad).
In Microsoft Project for Macintosh, you can press COMMAND+OPTION+*
(asterisk on the numeric keypad).
Keywords : kbdta kbdtacode
Version : WINDOWS:3.0,3.0a,4.0,4.1,4.1a,98; MACINTOSH:3.0,4.0
Platform : MACINTOSH WINDOWS
Issue type : kbhowtoLast Reviewed: May 18, 1999