EnableFieldList Property
False to disable the ability to display the field well for the PivotTable. If the field list was already being displayed it disappears. The default value is True. Read/write Boolean.
expression.EnableFieldList
expression Required. An expression that returns a PivotTable object.
Example
This example determines the the viewing status of the field well for the PivotTable and notifies the user. The example assumes that a PivotTable exists on the active worksheet.
Sub CheckFieldWell()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Determine if field well can be seen.
If pvtTable.EnableFieldList = True Then
MsgBox "The field well for the PivotTable can be displayed."
Else
MsgBox "The field well for the PivotTable cannot be displayed."
End If
End Sub