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.

"pawter" wrote:

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