Pivot Table

[Uddinj1]

Hi All,

How can I ran a macro everytime a pivot table changes including when the user
refresh the table or change for instance row filed to column field. The sheet
where the pivot table resides is added by another macro everytime the user
decides to ran a report.

I am using Excel 2000.

Thanks for your help.

Regards

UJ

 

[Debra Dalgleish]

Use the Worksheet_Calculate event to run the macro. For example:

Private Sub Worksheet_Calculate()
MsgBox "Run Macro Here"
End Sub

For information on Event procedures, see Chip Pearson's site:

http://www.cpearson.com/excel/events.htm