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

T

TNandSEC

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
 
T

Thomas Ramel

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?
Click to expand...

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]
 
Top