PivotTable.EnableFieldList Property (Excel)
False to disable the ability to display the field list for the PivotTable. If the field list was already being displayed it disappears. The default value is True. Read/write Boolean.
Syntax
expression .EnableFieldList
expression A variable that represents 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