This documentation is archived and is not being maintained.

EnableFieldList Property [Excel 2003 VBA Language Reference]

Office 2003

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.


expression Required. An expression that returns a PivotTable object.


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."
        MsgBox "The field list for the PivotTable cannot be displayed."
    End If

End Sub

Applies to | PivotTable Object