Chris,

Thanks for your reply. Another poster suggested a different workaround,
namely holding down the SHIFT key while doing the open. After trying the
SHIFT key method and fixing the code, I went back and opened normally and
replied DISABLE to the macros question and, sure enough, the file opened just
fine and did not start executing the code.

Thanks,

Phil

"Chris" wrote:

Open excel and set your Macro Security to Medium. When you open the workbook
with the code, select Disable Macros. You will be able to edit the code
without the macros running. When you are done with the fix, save, close,
reopen and Enable Macros.

"pwrichcreek" wrote:

I have VBA event code in an EXCEL workbook that goes into a never-ending
loop. I know what the problem is -- it triggers its own event! -- but I don't
know how to edit the errant code without opening the workbook. Is there a way
to edit the code without opening the workbook?

TIA,

Phil