Does anyone know about this and why it's happening? I used to be able
to bypass any Auto_Open (or Worksheet_Open) code by holding down Shift
while I open the spreadsheet... this is no longer working. My code runs
anyway, which makes it very difficult to modify/test code that's in an
Auto_Open procedure. Oddly enough, the "hold down Shift" method still
works just fine for Access 2007 and Word 2007.

Any ideas on how to get this working in Excel? I know I could set my
macro security to "Disable" and then change the code, then change my
security... then run the code and hope there are no errors.. then
change the security back to make changes... but that's a pretty huge
pain in the @$$.

Why on earth would they take away such a vital debugging feature?

WATYF