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