Can't access Excel VBA Code

Question

I have an Excel file with some VBA code. That code also includes a Form that is displayed on auto_open() call.

I never had problems opening VBA code form developers tab before. But now when I open that file it automatically calls the auto_open() (the form is displayed) and I can't access the code anymore. If I close the form the file is closed as well.

This problem started when I shut down Excel from the task manager because the VBA code was hanging. Since then I couldn't access the VBA for ANY other file containing forms loaded from auto_open().

NOTE: I already tried opening the file with the Shift key hold.

What is the problem? How can I access to the VBA macros as I used to do?

Thanks Miguel

Answer 1

Here's the way I managed this:

Rather than double-clicking the file in Windows I did:

1. Opened Excel
2. File -> Open
3. Browsed the file and hold the "shift" key while clicking on "Open". (continue holding it until the workbook finishes loading)