stopping workbook_open event from running

born2bongo

New Member
Joined
Feb 4, 2009
Messages
12
Having nightmares switching between excel 2003/2007. Need to start a 2003 workbook without the workbook_open macro kicking in, so I can see where my errors are coming from.

I used to just open witht the shift key down but this doesn't seem to work in 2007.

Also, maybe I'm asking the wrong questions but I've just spent an hour googling variations of this question, to no avail. Is there a fault with my Excel installation that is stopping the shift key from having an effect?

I'm running on XP.

TIA
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I don't have access to Excel 2007 at the moment so I can't check if holding down Shift works. But you could try temporarily setting your Macro Security to Low or typing:

Application.EnableEvents = False

in the VBE Immediate window and pressing Enter before opening the workbook.
 

born2bongo

New Member
Joined
Feb 4, 2009
Messages
12
Thanks for the quick response but no luck so far. Why did they have to take something so useful away?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,166
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I think Andrew meant setting your macro security to High rather than Low, but disabling events should work in all versions of Excel. Is it definitely a Workbook_Open event not an Auto_Open macro?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I think Andrew meant setting your macro security to High rather than Low, but disabling events should work in all versions of Excel. Is it definitely a Workbook_Open event not an Auto_Open macro?

Oops! :oops: My excuse is I was on the phone while typing.
 

born2bongo

New Member
Joined
Feb 4, 2009
Messages
12
OK. Disabling events worked the second time I tried it - must have panicked and did something wrong first time.

Thanks v much
 

Watch MrExcel Video

Forum statistics

Threads
1,123,494
Messages
5,602,004
Members
414,490
Latest member
Rip181

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top