Workbook_SheetChange will not fire

  • Thread starter Thread starter Robert Willard
  • Start date Start date
R

Robert Willard

I have a workbook that does a lookup to an Access
database. It was working fine, until i made some changes
to the Workbook_SheetChange sub. Now that event will not
fire, nor will the Workbook_BeforeSave.

The code is signed with my selfcert, and it had been
working fine before... any thoughts as to what would keep
it from firing?

Thanks!
Robert Willard
AB Microtech
 
Hi Robert,

The first thing I'd look for is to make sure you haven't set
Application.EnableEvents = False somewhere in your code without also setting
it back to True. This is a persistent setting, so if you turn it off without
turning it back on, all Excel events will be disabled until Excel is
restarted.

--
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 *
 
Back
Top