Hello,
I am wondering if anyone can please suggest a way to automatically run a macro, each time an item in a slicer is selected. Currently, I'm using a button that needs to be clicked to run the macro. The problem is the button needs to be clicked each time, after selecting the item in the slicer. I would like to automate this. Is there a VBA code/event change that I can use to automatically run the macro? Or a work-around?
I am wondering if anyone can please suggest a way to automatically run a macro, each time an item in a slicer is selected. Currently, I'm using a button that needs to be clicked to run the macro. The problem is the button needs to be clicked each time, after selecting the item in the slicer. I would like to automate this. Is there a VBA code/event change that I can use to automatically run the macro? Or a work-around?
