Application.PivotTableSelection Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .PivotTableSelection

expression A variable that represents an Application object.

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
Show: