DragToPage Property

Applies To

PivotField object.

Description

True if the field can be dragged to the page position. The default value is True. Read/write Boolean.

See Also

DragToColumn property, DragToHide property, DragToRow property.

Example

This example prevents the Year field from being dragged to the page position.

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