I've got a number of event handlers in an Excel spreadsheet and they seem to be interfering with each other and/or Excel is getting "confused".

I have Worksheet_Change in two worksheets triggering various macros when certain cells change.
I have Workbook_Open to initialize a global variable and check to see if this is the latest version of the workbook.
I have Workbook_BeforePrint to check the global variable and if it's been set (by one of the change events), prompt the user to see if they want to print both worksheets.

When I first open my file and Excel, everything works great. Then if I close the file (not Excel) and reopen the file, things start to degrade. Sometimes the Open won't trigger. Sometimes the Print won't trigger. And Sometimes one or all of the change procedures won't work. But if I close Excel and open it all again, they work fine.

Anybody have any ideas what's going on and how I can fix it? I didn't want to post all the code here since there's so much of it, but if there are parts of it that would help troubleshoot this issue, I'm happy to post it.

Thanks much!

I've never seen anything like this.

The code may be corrupted although this is not certain by any means. You could try Rob Bovey's Code Cleaner http://www.appspro.com/utilities/Cleaner.asp to try and sort it. Otherwise I'm out of ideas.

There are, of course, standard reasons why events may not fire off (written about Workbook_Open):
1) If you turn off events, then workbook_open won't fire.
2) If you hold down the control or the shift key when you're opening a workbook, auto_open and workbook_open won't fire.
3) If you are opening a workbook via a macro and you used a shortcut key for that macro that included the shift key, then excel gets confused and will not fire the workbook_open or auto_open.

But it doesn't sound like any of these are the problem.

Ooops, that link dosen't work. Have a look on google for Rob Bovey's Code Cleaner and you should find it soon enough.

Maccas

Thanks so much. You were right...I had a line I didn't need in the Workbook.BeforePrint macro (application.enableevents = false) so once I printed, nothing else would work because they were disabled.

Thanks again!