PivotField.DragToHide Property

  • Article
Excel Developer Reference

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

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.

Visual Basic for Applications 
  Worksheets(1).PivotTables("Pivot1") _
    .PivotFields("Year").DragToHide = False

See Also