Edit VBA Code without opening the workbook
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
|