Can i get a macro to run everytime i use a pivot table splitter?

[tonywatsonhelp]

Hi Everyone

I was wondering if anyone would know of a way I could get a macro to run when click on a pivot table splitter?

I'm use a chart and need a macro called "chrt" to rum so the parameters are correct?

I was wondering if there was a trigger in the sheet part of vba where you do the On Activate etc to say when pivot table is changed?

Tony

 

[RickXL]

Hi,

I assume you mean "slicer" rather than "splitter"?

If so, the Worksheet_PivotTableUpdate event appears to be triggered every time you make a change to the Pivot Table.

You can find a list of available events by going into the VB Editor for that worksheet, selecting Worksheet from the dropdown at the top left thn looking in the drop down at the top right to see what is available.

I just tried out all the Pivot Table ones. I expect there is a more scientific way.


Regards,