can i build a marco to run automatically after making a selection of field
in pivot table?

dennis

Dennis,

Quite simply ... use

Private Sub Worksheet_Calculate()
Application.EnableEvents = False
Run ("TheNameofYourMacro")
Application.EnableEvents = True
End Sub

HTH
Carim

Dear Carim,

i save the code in sheet1, my table is in sheet1. but the marco didn't run.
can u help again?

Dennis

"Carim" wrote in message
ups.com...
Dennis,

Quite simply ... use

Private Sub Worksheet_Calculate()
Application.EnableEvents = False
Run ("TheNameofYourMacro")
Application.EnableEvents = True
End Sub

HTH
Carim

Dennis,

Just type =Now() in any cell of your sheet1 ...

HTH

Carim

Carim,

i am sorry that it didn't work as i follow your instruction. do i miss
anything or did something wrong?

Dennis

dennis
"Carim" wrote in message
ps.com...
Dennis,

Just type =Now() in any cell of your sheet1 ...

HTH

Carim

Because the pivot table is an object, its refresh does not trigger a
worksheet calculate event, therefore you need a volatile function such
as now() or any function linked to the result of your pivot table being
recalculated such as
=MATCH("Grand Total",A:A,1) to fire the event...

HTH

Carim