refresh event pivot
 

I'd like to know simple code to trigger my code on a refresh or change event
on a pivot. Just not sure how to get it to activate..

thanks,

--
Regards,

Donica

refresh event pivot
 

If you are using XL2002 or better then there is a refresh table event in VBA.
In the sheet with the pivot table add this code...

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub

If you are using a version of XL prior to 2002 then there is no event and
you need to catch the calculate event or something similar which carries a
lot of overhead with it...
--
HTH...

Jim Thomlinson


"Donica" wrote:

I'd like to know simple code to trigger my code on a refresh or change event
on a pivot. Just not sure how to get it to activate..

thanks,

--
Regards,

Donica