DragToColumn Property

Applies To

PivotField object.

Description

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

See Also

DragToHide property, DragToPage property, DragToRow property.

Example

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

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