| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Application.PivotTableSelection property (Excel) |
vbaxl10.chm133192 |
|
|
e0a93c11-2e2f-23af-6cad-b4f22883128e |
04/05/2019 |
medium |
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[!includeSupport and feedback]