PivotTableSelection Property

Applies To

Application object.

Description

True if PivotTables use structured selection. Read/write Boolean.

See Also

SelectionMode property.

Example

This example enables structured selection mode and then sets PivotTable one to allow only data to be selected.

Application.PivotTableSelection = True
Worksheets(1).PivotTables(1).SelectionMode = xlDataOnly