Thread: run macro automatically when user changes the data poit in Pivot c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta[_4_] Tushar Mehta[_4_] is offline
external usenet poster
  
Posts: 66
Default 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
Reply With QuoteReply With Quote