Application.FilterShowSummaryRows method (Project)
Shows or hides the related summary rows.
expression. FilterShowSummaryRows
( _On_
)
expression An expression that returns an Application object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
On | Required | Boolean | True if summary rows are shown; otherwise, False. |
Boolean
The FilterShowSummaryRows method corresponds to the following command on the ribbon: on the View tab, click the Filter drop-down list box in the Data section, and then click Show Related Summary Rows.
If the current filter shows only completed tasks, for example, the following command shows the summary tasks.
FilterShowSummaryRows (true)
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.