Problem with VBA in Excel

[Enoch11]

I wrote an application in VBA (Excel). On startup of my application shows a menu with control buttons. The application works fine on the computer on which it was written. However on other computers, as soon as Excel starts, an error msg is shown: "Microsoft Excel has encountered a problem and needs to close". The same problem occurs in Excel 2002 and 2007.
How can I stop execution of the application before the error msg is shown? Ctrl+Break doesn’t work. How can I get access to the code, to try and make changes?

 

[Jonmo1]

Welcome to the board.

Open any other excel document.
Disable Macros
Close Excel

Then you should be able to open the troublesome document.


Also, I think you can just hold down the Shift Key when open the document.
That disables macros for that session.

Hope that helps.

 

[Enoch11]

Welcome to the board.

Open any other excel document.
Disable Macros
Close Excel

Then you should be able to open the troublesome document.


Also, I think you can just hold down the Shift Key when open the document.
That disables macros for that session.

Hope that helps.

Thanks.
It did not help. Still Excel crashes.