EnableFieldList Property

Microsoft Excel Visual Basic

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