Hmm in fact I would like the marco to be run everytime the pivot graph
was actually re-draw wheather it be by a changing the page field or
anytime changes were made to the buttons on either axis.

Hope i make scene

Cheers

Paul


--
paulbrown
------------------------------------------------------------------------
paulbrown's Profile: http://www.excelforum.com/member.php...o&userid=32852
View this thread: http://www.excelforum.com/showthread...hreadid=565524