PivotTable.EnableFieldList property (Excel)

  • Article

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 whether the field list for the PivotTable can be displayed 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.