Thanks for that, "Worksheet_Calculate" worked just how id hoped. My drill
down/up is the type where the pivot table expands rather that generates a new
sheet, so the calculate solution is the best to use for now. Thanks also to
Tom as the new sheet event will probably come in handy sooner or later.

:)

Martyn

"MIKE215" wrote:

Hi Martyn,

So far as I know, there are know pivot table events. The worksheet
calculate event fires when the pivot table changes as a result of a drill up
or down. Depending on your purpose that might make a good substitue.

Regards,
Mike

"Martyn Upson" wrote:

Is it possible to trigger an event on vba when a user drills down (or back)
in a pivot table. Is there anything like: ?

sub PivotTable.OnDrillDown

End Sub

Thanks