Macro to Run when Slicer Selection is Changed (multiple slicers)

Hi All,

I was searching for a way to run macro whenever I select an item on a slicer or whenever the selection is changed. The closest I found was the thread below.

http://www.excelforum.com/excel-prog...s-changed.html

Since I'm new to this I don't know where to put the macro and how to apply it on multiple slicers. The first Slicer has a category and the other has the sub category. I need it to run every time selection is changed on either slicer.

This is the macro I want to run if it helps.

Sub Button1_Click()
    Rows("5:46").EntireRow.AutoFit
End Sub