Shift key doesn't stop Auto_Open() from firing

J

Jeff Hunt

I have an Excel workbook that is opened from another program. The workbook
has an Auto_Open macro to perform several tasks each time it is opened. When
I am trying to work on the code, it seems that holding down the Shift key
when I open the workbook does not prevent the macro from executing
automatically. I thought that in the past holding Shift had always prevented
the code from running. Has anyone else run into this or know how to get it
working again?
 
B

Bernie Deitrick

Jeff,

Posting your code would help, but try setting the Excel Object's
EnableEvents property to false prior to opening the file, and set it back to
true after...

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bypass Auto_Open 13
Auto_Open Macro 5
Auto_Open disabling 7
Auto_Open Code on Worksheet 2
Skipping Auto_Open 6
Triggering auto_open 5
Stop macro 1
with a macro open a workbook without the Auto_Open running 3

Top