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.

Visual Basic for Applications 
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
enable field list enablefield enablefieldlist enablefieldlist property

See also: