View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default Edit VBA Code without opening the workbook

"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.