How To Fire Macro after -----

[Perrister]

I have set up a slicer that controls 2 different pivot tables attached to the same data, very simple basically synchronizes the tables based on user selection.

After the selection I would like the to fire a macro that re-sizes columns to data for best fit. if I turn on auto-size columns within pivot tables columns are too wide, if I select ALL CELLS then auto fit looks beautiful but I would like for this to happen automatically after user selection.

I have assigned macro to Slicer but then lose slicer functionality, basically fires macro every time you touch slicer, unless you right click, then you can use slicer, but macro does not fire.

I am using Excel 2010.

The desired is for user to select quarter for view, then pivots synch to user selection, then columns auto fit for neatness.

Thanks,
Perry

 

[ghrain22]

Have the macro fire on pivottable update instead.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
    'Code
End sub

It would have to be in the worksheet of the pivottable, but I believe it'd accomplish what you want.

 

[Perrister]

Have the macro fire on pivottable update instead.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
    'Code
End sub

It would have to be in the worksheet of the pivottable, but I believe it'd accomplish what you want.

thank you