run macro every time page field change is changed

[paulbrown]

Hello

I was wondering how I might go about running my recorded macro...

Sub apply_formatting()

...everytime the user changes the pivot page field inside my Excel 2003 pivot chart?

Many thanks in advance,

Paul

[paulbrown]

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