Slicer Macro defeats slicer functionality

[dmcgimpsey]

Hi Team:

I have assigned a macro to a slicer object, but when I click on the slicer button, the macro executes but the slicer doesn't work.

To keep it simple, the slicer only has a msgbox("Slicer clicked")


My intention is to use slicers to run - and to then filter the raw data spreadsheet based on all the slicer settings - this lets the user export the raw data as they see fit. the data is in an excel table, which is not relevant to this issue, but it is best practice for multiple pivots and slicers

Thanks for your help - and I did check at least 20 posts and could not find an answer - i appreciate your help her.

Regards

Don

 

[RoryA]

I'm afraid that's just how it is. You should use an alternate trigger for your code, such as a pivottableupdate event.

 

[dmcgimpsey]

Thanks for the quick reply, and I will definitely try your suggestion.

Can mark this as closed.

Regards