EnableFieldList Property [Excel 2003 VBA Language Reference]

  • 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.

expression.EnableFieldList

expression Required. An expression that returns 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

Applies to | PivotTable Object