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
Enable structured selection on pivottable? Find out if current pivot table uses structured selection? pivot table selection Pivot Table Selection Property PivotTableSelection PivotTableSelection Property

See also: