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