Change format on pivot change
Posted on 2015-02-19
I have some code that reformats pivots on refresh (no matter how much ive tried, the formatting keeps changing on refresh)
Its fine except there are pivots over a couple of tabs so the user ends up on a different tab after pressing a slicer.
Instead of calling the format code on change on Workbook_SheetPivotTableUpdate(ByVal Sh As Object, ByVal Target As PivotTable)
Can I call the code if a certain slicer is clicked?