Howard,

Many thanks for your reply. It did the trick.

Then, the first time (after fixing the code) I opened the workbook WITHOUT
holding the SHIFT key, it dawned on me that, if I just replied "disable" to
the allow macros question, it probably would have worked as well. And,
indeed, another poster replied after yours and made that very suggestion.

Thanks,

Phil

"Howard Kaikow" wrote:

"pwrichcreek" wrote in message
...
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?

Hold the SHIFT key when you open the workbook to prevent code from running.