open book event.....crash office????

[alcorjr]

Hi guys, I've been stuck on this problem for a couple of hours, and for all my worth I'm uncapable of finding it.
The trouble is exactly as the subject of the post describes. This book won't let me list any command under the Open Book event, It started with not letting a Userform.Show command. As I've continued to investigate, I've found that it won't let me do anything. I've tried placing some error handlers but, obviously the code doesn't even get to that line, 'cause as soon as I open it it crashes....
Where should I look for trouble? I compile and get nothing..

What gives???????
Thanks :wink:

 

[BrianB]

workbook or code modules may be corrupted.
Does this still happen if you remove all your code modules/Save/Open ?

 

[alcorjr]

Thanks for your reply, Brian.
Now that you mention it, there must be something wrong with the code, 'cause thinking back, I remember now that specifically form1 was causing it to crash on Query close, but what do I do?.....do I strip all the modules from the book, write some command under Open Book, and start importing each one-save and open to see which one is giving the problem, or is there some quicker way to purge the code?
I have the code cleaner add-in and have used it, but it doesn't help

Cheers

I'm definetely gonna start my day with a cup of coffee (as I always do)

 

[BrianB]

Usual way of cleaning code is to copy/paste to Notepad, remove the module, copy/paste back from Notepad. I suggest you do a save in between (without the code) to try in case this is not the problem.