Application.FilterShowSummaryRows method (Project)
Shows or hides the related summary rows.
Syntax
expression. FilterShowSummaryRows( _On_ )
expression An expression that returns an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| On | Required | Boolean | True if summary rows are shown; otherwise, False. |
Return value
Boolean
Remarks
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.
Example
If the current filter shows only completed tasks, for example, the following command shows the summary tasks.
FilterShowSummaryRows (true)
Support and feedback
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.