DragToHide Property

Applies To

PivotField object.

Description

True if the field can be hidden by being dragged off the PivotTable. The default value is True. Read/write Boolean.

See Also

DragToColumn property, DragToPage property, DragToRow property.

Example

This example prevents the Year field from being dragged off the PivotTable.

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