Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
EndArrowheadStyle Property
EndArrowheadWidth Property
EndConnected Property
EndConnectedShape Property
EndConnectionSite Property
EndStyle Property
EntireColumn Property
EntireRow Property
EnvelopeVisible Property
ErrorBars Property
ErrorCheckingOptions Property
ErrorMessage Property
Errors Property
ErrorString Property
ErrorTitle Property
EvaluateToError Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExpandHelp Property
Explosion Property
ExtendList Property
Extent Property
ExtrusionColor Property
ExtrusionColorType Property
Expand Minimize

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

© 2015 Microsoft