SelectionMode Property 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

In this example, the PivotTable report is in outline form.

Application.PivotTableSelection = True
Worksheets(1).PivotTables(1).SelectionMode = _
    xlDataOnly + xlFirstRow