PivotTableSelection Property [Excel 2003 VBA Language Reference]

  • Article

True if PivotTable reports use structured selection. Read/write Boolean.

Example

This example enables structured selection mode and then sets the first PivotTable report on worksheet one to allow only data to be selected.

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

Applies to | Application Object

See Also | SelectionMode Property