|
-
Jan 27th, 2012, 07:05 PM
#1
Thread Starter
Frenzied Member
How to Find what's wrong.
Hi and thanks for reading. I've mentioned this before but not had any luck with a solution.
My macro's are crashing with a page fault, which makes it impossible for me to debug as not
only does Excel have to restart all the time but the 'fault' seems to change as
different Forms or Modules are added or removed - trying to isolate the problem.
So I have reduced it to a 16MB xlsm file where I can repeatedly do this :-
There's a STOP statement in the first line of Workbook_Open. The xlsm file loads and
stops as expected. At this point just entering Stop in Workbook_Open causes the hourglass to appear
momentarily and then
Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience.
Similarly if I add a breakpoint in Workbook_Open then just scroll the mouse up and down a few times
the same thing happens.
Pressing F5 on the Stop statement, may immediately repeat the above, or display error 57121 and then crash very
soon afterwards. The highlighted error is on a line that has no error.
How can I proceed to find the cause of this? Does anyone know why it crashes just by adding Stop?
Do this cause some kind of recompile? Can it be something in my code, even though it hasn't actually executed yet?
I have rebuilt the xlsm piece by piece after an Excel re-install, and also the same problem happens on more than just my computer.
Any suggestions very much appreciated - PLEASE!!!
Thanks, ABB
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|