Hi.
I have some VBA code in a module that makes changes to a file. That macro works perfectly.
However, I want it to activate (rather than me having to run it manually) either when a slicer selection changes to any different selection - doesn't matter what the selection is I just need it to process the data in the other macro accordingly (slicer is called Slicer_Month on a sheet called Dashboard) , or alternatively run when the output of that slicer change makes a pivot table value update (Cell F7 on a sheet called Pivots).
I have looked at using worksheet_change and worksheet_calculate functions but with limited success.
The additional challenge is that i also want the other macro to run when another slicer has its selection change (also doesn't matter what the selection is) - the second slide is called Slicer_Month 1 on the Dashboard sheet and the pivot value is F34 on the Pivots sheet.
The macro to be called is called Paired_Scores
Can anyone point me in the right direction please?
Thanks.
Liz.