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