Thread: How to execute a macro when data in a pivotchart changes?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Thomas Ramel Thomas Ramel is offline
external usenet poster
  
Posts: 70
Default How to execute a macro when data in a pivotchart changes?
Grüezi TNandSEC

TNandSEC schrieb am 04.06.2004

Can someone tell me how to link a macro to a pivotchart so that once the
pivotchart has been updated (by the user selecting a single item from a
drop-down-list), the macro will be executed?

How about the Calculate-Event of the worksheet that holds the piovt-table?

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]
Reply With QuoteReply With Quote