Shift key doesn't stop Auto_Open() from firing

[Jeff Hunt]

I have an Excel workbook that is opened from another program. The workbook
has an Autpen 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?

 

[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