Cannot get access to the code.

Enoch11 · May 19th, 2011, 06:03 PM

I wrote an application in Excel VBA. On startup, 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 my application before the error msg is shown? Ctrl+Break doesnât work. Disabling Macros doesnât help. How can I get access to the code, to try and make changes?
Thanks.

JP · May 19th, 2011, 09:07 PM

Put the word "Stop" at the beginning of your code, i.e.

Code:

Private Sub Workbook_Open()
Stop
' rest of your code
End Sub

Enoch11 · May 20th, 2011, 01:06 AM

Quote:

Originally Posted by JP

Put the word "Stop" at the beginning of your code, i.e.

Code:

Private Sub Workbook_Open()
Stop
' rest of your code
End Sub

But I cannot access the code.

JP · May 20th, 2011, 06:45 AM

Not even on the computer you wrote it on?

You said:

Quote:

The application works fine on the computer on which it was written.

Put "Stop" at the beginning of your code, then put the application on another computer and run it.