Export (0) Print
Expand All
Expand Minimize

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



Community Additions

ADD
Show:
© 2014 Microsoft