Open sheet in Developer mode

Question

Hello, I need help please.

I have an excel worksheet that opens a InputBox upon opening but I have an error in my code. Part of the code is to close the worksheet if the cancel button is selected. Now no matter if I put anything in the Input field or select the OK button it acts as if I selected the cancel button and the worksheet closes.

How can I open the worksheet and get access to the code?

Thanks in your advance for your help.

Rich

Answer 1

Hi Normal,

I tried the Shift Key method, and it did not help. However, I was able to access my code by pressing the Ctrl+Break keys.

Thank you.

Rich

Answer 2

Hi Rich,

I have an excel worksheet that opens a InputBox upon opening but I have an error in my code. Part of the code is to close the worksheet if the cancel button is selected. Now no matter if I put anything in the Input field or select the OK button it acts as if I selected the cancel button and the worksheet closes.

How can I open the worksheet and get access to the code?

Keep the shift key depressed when you open the file. This should disable the Workbook_Open procedure and enable you to access your code.

Alternatively, before opening the problematic file, type the following instruction in the immediate window of the VBA editor and press Return:

        Application.EnableEvents=False  

This will disable all event code from running until you change this setting to True or you restart Excel

===

Regards,

Norman