Hello All,
As the title of my post suggests, I'm interested in understanding whether it's possible for a macro to run whenever a Pivot Table Field is dropped in or taken out of the main body of a Pivot Table.
I am aware of the 'PivotTableUpdate Event', but I believe this only works when a Pivot Table is being refreshed (though I could be wrong).
Can anybody point me in the right direction in terms of how I could go about doing this?
Thanks in advance.
Matty
As the title of my post suggests, I'm interested in understanding whether it's possible for a macro to run whenever a Pivot Table Field is dropped in or taken out of the main body of a Pivot Table.
I am aware of the 'PivotTableUpdate Event', but I believe this only works when a Pivot Table is being refreshed (though I could be wrong).
Can anybody point me in the right direction in terms of how I could go about doing this?
Thanks in advance.
Matty