Export (0) Print
Expand All
E
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.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


Show:
© 2014 Microsoft