EnableFieldList Property

Microsoft Excel Visual Basic

EnableFieldList Property

       

False to disable the ability to display the field well 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 the viewing status of the field well for the PivotTable and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub CheckFieldWell()

    Dim pvtTable As PivotTable

    Set pvtTable = ActiveSheet.PivotTables(1)

    ' Determine if field well can be seen.
    If pvtTable.EnableFieldList = True Then
        MsgBox "The field well for the PivotTable can be displayed."
    Else
        MsgBox "The field well for the PivotTable cannot be displayed."
    End If

End Sub