It worked ok for me from windows explorer (win98 and xl2002).

The auto_open code didn't run and neither did the workbook_open event.

Ron de Bruin wrote:

Hi

The shift key is only working if you open the file from within Excel.
Not if you open it from the Windows explorer

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"RzB" wrote in message ...
I would like to know how to stop the Auto Open
macro from running on start up. I sort of expected
to be able to hold down the shift key similar to the
way Access works. But that don't work. Interestingly
I found an old post on Google that sort of suggests it
should.

Is there some higher level setting that is overriding
the shift key?

Many thanks,
Roy



--

Dave Peterson