Stop Workbook_Open macro

**munkayboi** · 06-11-2007, 11:57 AM

Hello everyone,

I was wondering if there was a way to stop a WorkBook_Open macro from running. Apparently, there is something wrong with the code (maybe an infinite loop somewhere or a really bad query) and it is located in the WorkBook_Open function, so I need a way to turn it off in order to setup breakpoints and debug it. Any help would be greatly appreciated, thanks!

**bhofsetz** · 06-11-2007, 12:03 PM

One option that I've used is to open the workbook with macros disabled then
add a message box indicating where you are in the code. Save the workbook
then close and reopen it, this time enabling the macros.
When the message box pops up in the Workbook_Open sub before responding
to the message box enter break mode (hit [Ctrl]+[Break]) and then you can
step through your code or add breakpoints, etc.

HTH

**munkayboi** · 06-11-2007, 12:13 PM

Hi bhofsetz,

How do you open the workbook with disabling macros? I know that it usually prompts you whether you want to enable or disable macros before the workbook is opened, but I am not receiving that prompt for some reason. Any ideas?

**munkayboi** · 06-11-2007, 12:16 PM

Nevermind, I managed to interrupt the code by spamming ctrl+break once I opened the workbook. Thanks a lot for your help!

**bhofsetz** · 06-11-2007, 12:36 PM

Your security settings are probably set to low and that is why you are not
receiving the message. Change the security settings to Medium and then
you should receive the message to enable or disable macros upon opening
the workbook.

HTH