suppress Workbook_Open event

[pawter]

I'm using XL2003 Pro and wish to achieve the above when manually
opening a workbook. All my reference-books (& I think I can recollect
having used this a couple years ago) say it can be done by holding
down the Shift key. But no such luck ... any ideas anyone?

thanks in advance,
Tom

 

[Joel]

There are four ways I know of stopping the macro from running

1) Open excel in safe mode. From the start button press Run and enter
"Excel /safe".

2) Set the security level to Medium and when the work book opens select
Disable Macros.

3) Add an input box to the Startup Routine asking if you want to run the
Startup routine. then add an IF statement to run routine depending on the
response.

4) Change the name of the Workbook_open event (AWorkbook_open) and save
book. Then re-open.

 

[Jim Rech]

The Shift key always works for me. You're holding Shift down when you click
"Open" right?

Another way is to turn events off before opening the workbook:

Run a macro that includes this line: Application.EnableEvents = False

This suppresses the Workbooks_Open event (and any others) but not sub
Autpen.

--
Jim
| I'm using XL2003 Pro and wish to achieve the above when manually
| opening a workbook. All my reference-books (& I think I can recollect
| having used this a couple years ago) say it can be done by holding
| down the Shift key. But no such luck ... any ideas anyone?
|
| thanks in advance,
| Tom
|