I have an Excel 2004 (Win XP Pro) Workbook that has an
Auto_Open macro. I have to change the logic in that macro,
but it is necessary that I disable the macro before it
executes when I open the workbook. In the past I would
simply press & hold the SHIFT key while opening the
workbook, and that would bypass Auto_Open execution. For
some reason today that isn't working. The purpose of the
macro is to open about 8 other workbooks, then close the
workbook it is in. It's been working beautifully for
years, now all of a sudden I can't disable it. What am I
missing? Is there an alternative way of turning it off.
As I said, if it executes, it closes the workbook it's in,
so I never have a chance to get to it.
(Groan)