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

EnableItemSelection Property [Excel 2003 VBA Language Reference]

Office 2003

When set to False, disables the ability to use the field dropdown in the user interface. The default value is True. Read/write Boolean.


expression Required. An expression that returns a PivotField object.


A run-time error will occur if the OLAP PivotTable field is not the highest level for the hierarchy.


This example determines the setting for selecting items using the field dropdown and enables the feature, if necessary. The example assumes a PivotTable exists on the active worksheet.

Sub UseEnableItemSelection()

    Dim pvtTable As PivotTable
    Dim pvtField As PivotField

    Set pvtTable = ActiveSheet.PivotTables(1)
    Set pvtField = pvtTable.RowFields(1)

    ' Determine setting for property and enable if necessary.
    If pvtField.EnableItemSelection = False Then
        pvtField.EnableItemSelection = True
        MsgBox "Item selection enabled for fields."
        MsgBox "Item selection is already enabled for fields."
    End If

End Sub

Applies to | PivotField Object

© 2015 Microsoft