ShowPageMultipleItemLabel Property

Microsoft Excel Visual Basic

ShowPageMultipleItemLabel Property

       

When set to True (default), "(Multiple Items)" will appear in the PivotTable cell on the worksheet whenever items are hidden and an aggregate of non-hidden items is shown in the PivotTable view. Read/write Boolean.

expression.ShowPageMultipleItemLabel

expression   Required. An expression that returns a PivotTable object.

Example

This example determines if "(Multiple Items)" will be displayed in the PivotTable cell and notifies the user.  The example assumes that a PivotTable exists on the active worksheet.


Sub UseShowPageMultipleItemLabel()

    Dim pvtTable As PivotTable

    Set pvtTable = ActiveSheet.PivotTables(1)

    ' Determine if multiple items are allowed.
    If pvtTable.ShowPageMultipleItemLabel = True Then
        MsgBox "The words 'Multiple Items' can be displayed."
    Else
        MsgBox "The words 'Multiple Items' cannot be displayed."
    End If

End Sub