stopping workbook_open event from running

[born2bongo]

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

 

[Andrew Poulsom]

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]

Thanks for the quick response but no luck so far. Why did they have to take something so useful away?

 

[RoryA]

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 Autpen macro?

 

[Andrew Poulsom]

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 Autpen macro?

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

 

[born2bongo]

OK. Disabling events worked the second time I tried it - must have panicked and did something wrong first time.

Thanks v much