expression.EnableFieldList
expression Required. An expression that returns a PivotTable object.
Example
This example determines the whether the field list for the PivotTable can be displayed or not and notifies the user. The example assumes that a PivotTable exists on the active worksheet.
Sub CheckFieldList()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Determine if field list can be displayed.
If pvtTable.EnableFieldList = True Then
MsgBox "The field list for the PivotTable can be displayed."
Else
MsgBox "The field list for the PivotTable cannot be displayed."
End If
End Sub