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

alcorjr

Active Member
Joined
Dec 29, 2002
Messages
416
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??????? :eek: :eek:
Thanks :wink:
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
workbook or code modules may be corrupted.
Does this still happen if you remove all your code modules/Save/Open ?
 

alcorjr

Active Member
Joined
Dec 29, 2002
Messages
416
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
:p
I'm definetely gonna start my day with a cup of coffee (as I always do)
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,100
Messages
5,768,095
Members
425,452
Latest member
htay44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top