I'm trying to find a way to monitor changes within a PivotTable.
xlXP introduced the PivotTableUpdate event so no problem there..

To my dismay I noticed something unexpected in xl97...
I cant test xl2k but until told otherwise I'll presume it's the same.

Sub Worksheet_change(target as range)
beep
end sub

changing anything WITHIN a pivottable and
NO worksheet change event is fired...

...hmmm..

Anyone like to suggest a workaround ?


Jurgen Volkerink
aka keepITcool


keepITcool @ chello . nl
xlSupport.com | amsterdam | netherlands