xl97/xl2k events in pivottables

K

keepITcool

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
 
R

Rob Bovey

Hi Jurgen,

Unfortunately, the only event fired as a result of changing a PivotTable
in Excel 97/2000 is the Calculate event, so you have to figure out how to do
whatever you need using that.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
S

Steve Hieb

I recall having the same problem. Think I used Worksheet_Calculate
event instead as a workaround.

HTH,
Steve Hieb
 
Top