expression.ShowPivotTableFieldList
expression Required. An expression that returns one of the objects in the Applies To list.
Example
In this example, Microsoft Excel determines if the PivotTable field list can be shown and notifies the user.
Sub UseShowPivotTableFieldList()
Dim wkbOne As Workbook
Set wkbOne = Application.ActiveWorkbook
'Determine PivotTable field list setting.
If wkbOne.ShowPivotTableFieldList = True Then
MsgBox "The PivotTable field list can be viewed."
Else
MsgBox "The PivotTable field list cannot be viewed."
End If
End Sub