Application.PivotTableSelection Property (Excel)
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.
Application.PivotTableSelection = True
Worksheets(1).PivotTables(1).SelectionMode = xlDataOnly