Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to turn off dragging for a Pivot Table field
Hi,
Not sure what you mean by drag off. You can freeze a field using the below function PivotFieldFreeze. Pivot freeze would have to be called on each field. Sub test() Dim pf As PivotField Set pf = ActiveSheet.PivotTables(1).PivotFields("A") '<--- change field name here PivotFieldFreeze pf End Sub Function PivotFieldFreeze(PivotField As PivotField) With PivotField .DragToColumn = False .DragToData = False .DragToHide = False .DragToPage = False .DragToRow = False End With End Function "Prabhakar" wrote: Hi, Is there a way to turn off dragging for a Pivot Table. thanks prabhakar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
pivot table - dragging fields | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table - Dragging multiple items into data field | Excel Discussion (Misc queries) | |||
How to turn off dragging for a Pivot Table field | Excel Programming |