View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default Bypass Auto_open Macro in Excel 2007

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