Workbook_SheetChange will not fire
 

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

Workbook_SheetChange will not fire
 

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 *


"Robert Willard" wrote in message
...
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