PivotTableSelection Property [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
Application.PivotTableSelection Property
True if PivotTable reports use structured selection. Read/write Boolean.

Syntax

expression.PivotTableSelection

expression   A variable that represents an Application object.

Example

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

Visual Basic for Applications
Application.PivotTableSelection = True
Worksheets(1).PivotTables(1).SelectionMode = xlDataOnly

See Also