How to execute a macro when data in a pivotchart changes?
 

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?

Thanks


---
Message posted from http://www.ExcelForum.com/

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]

How to execute a macro when data in a pivotchart changes?
 

Can you provide more detail

--
Message posted from http://www.ExcelForum.com