PivotField.DragToHide Property

Syntax

expression.DragToHide

expression A variable that represents a PivotField object.

Example

This example prevents the Year field in the first PivotTable report on worksheet one from being dragged off the report.

Worksheets(1).PivotTables("Pivot1") _ .PivotFields("Year").DragToHide = False

See also:

• PivotField Object
• PivotField Object Members