Try Tools / Macro / Security / Set to very high, then open the workbook

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"SidBord" wrote in message
...
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)


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004