xl97/xl2k events in pivottables

  • Thread starter Thread starter keepITcool
  • Start date Start date
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
 
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 *
 
I recall having the same problem. Think I used Worksheet_Calculate
event instead as a workaround.

HTH,
Steve Hieb
 
Back
Top