Hi,
I have an Excel application that starts running code when it opens up in:
Public Sub Workbook_Open()
End sub
How can I make the code not execute or stop the debugger when opening the workbook?
Printable View
Hi,
I have an Excel application that starts running code when it opens up in:
Public Sub Workbook_Open()
End sub
How can I make the code not execute or stop the debugger when opening the workbook?
i seem to think there is a key to press
Quote:
Stop a macro while it is running
To stop a macro before it completes its actions, press ESC.
Quote:
Start Microsoft Excel without running automatic macros
Automatic macros, such as Auto_Activate, are designed to run when you start Excel. For more information about these macros, see Visual Basic Help.
To prevent macros from automatically running, hold down SHIFT while you start Excel.
Note If you start Excel from the Office Shortcut Bar, click the Microsoft Excel button on the Office Shortcut Bar first, and then immediately hold down SHIFT while Excel starts.
Open Excel with no workbooks. Set the security level to No Macros or Macros Disabled. Then open your workbook and viola! :D