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.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om