run macro every time page field change is changed

  • Thread starter Thread starter paulbrown
  • Start date Start date
P

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Pivot Table - change page field help 23
Re-run subroutine when pivot page field is changed 1
Pivot Table Macro Run-time error 3
Msg Box to appear when page selection changes in a Pivot Table 3
PivotItems updating pivottable 3
Excel 2007 Run-Time error 1
Pivot macro problem 2

Back
Top