Using only one of 4 slicers to triger Workbook_SheetTableUpdate event
I got 4 slicers - "Class", "Course", "Presenter" and "Topic" to update an identical pivot table. However, I just want the specific slicer, say the bottom layer of the 4 slicers - "Topic" to triger the Workbook_SheetTableUpdate event other than the rest ones otherwise. How can I modify the VBA script?
Alternatively, if I use Worksheet_PivotTableUpdate event
other than above mentioned Workbook_SheetTableUpdate event , how to change the code?
and the last but not least, it must be a way to run the VBA behind the scenes making it invisible while the cursor moves around the worksheet, right? How to make it happen?
|