I used to be able to hold down the shift key to bypass the auto_open macro in
older versions of MS Excel, this does not appear to work in MS Excel 2007.
How do I bypass the auto_open macro now?
--
BradJ

From an answer provided by Dave
Use file|open to select the file to open, then hit and hold the shift key
while clicking on the Open button, then clicking the "yes" button (to allow
macros--my security setting) while continuing to hold down the shift button,
the
auto_open procedure doesn't run.

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"BradJohnson" wrote:

I used to be able to hold down the shift key to bypass the auto_open macro in
older versions of MS Excel, this does not appear to work in MS Excel 2007.
How do I bypass the auto_open macro now?
--
BradJ

I have the macros security set to low, so I do not receive the prompt to
allow macros.
--
BradJ


"Sheeloo" wrote:

From an answer provided by Dave
Use file|open to select the file to open, then hit and hold the shift key
while clicking on the Open button, then clicking the "yes" button (to allow
macros--my security setting) while continuing to hold down the shift button,
the
auto_open procedure doesn't run.

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"BradJohnson" wrote:

I used to be able to hold down the shift key to bypass the auto_open macro in
older versions of MS Excel, this does not appear to work in MS Excel 2007.
How do I bypass the auto_open macro now?
--
BradJ

For me Auto_Open does not run when I press Shift while double clicking the
xlsm file...

This is what MS says
"If you want Excel to start without running an Auto_Open macro, hold down
the SHIFT key when you start Excel."

Source:http://office.microsoft.com/en-us/he...oAutomatically

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"BradJohnson" wrote:

I have the macros security set to low, so I do not receive the prompt to
allow macros.
--
BradJ


"Sheeloo" wrote:

From an answer provided by Dave
Use file|open to select the file to open, then hit and hold the shift key
while clicking on the Open button, then clicking the "yes" button (to allow
macros--my security setting) while continuing to hold down the shift button,
the
auto_open procedure doesn't run.

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"BradJohnson" wrote:

I used to be able to hold down the shift key to bypass the auto_open macro in
older versions of MS Excel, this does not appear to work in MS Excel 2007.
How do I bypass the auto_open macro now?
--
BradJ