DragToHide Property [Excel 2003 VBA Language Reference]

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


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

Applies to | CubeField Object | PivotField Object

See Also | DragToColumn Property | DragToPage Property | DragToRow Property