PivotTableSelection Property
TOC
Collapse the table of content
Expand the table of content

Application.PivotTableSelection Property

Office 2007
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



Show:
© 2016 Microsoft