run macro automatically when user changes the data poit in Pivot c
 

I have captured a macro when I made the cutom changes to my pivot chart. I
would like to run it automatically when the user changes the data point. I
mean my chart showing reps data by month, when selecting different rep I
would like to run the macro automatically. Is it possible. How do I do that.
Any help, really appreciate.

Thanks

run macro automatically when user changes the data poit in Pivot c
 

Check Excel's SheetPivotTableUpdate event. For more, see Excel VBA help.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Lin" wrote:

I have captured a macro when I made the cutom changes to my pivot chart. I
would like to run it automatically when the user changes the data point. I
mean my chart showing reps data by month, when selecting different rep I
would like to run the macro automatically. Is it possible. How do I do that.
Any help, really appreciate.

Thanks