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.