View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
pwrichcreek pwrichcreek is offline
external usenet poster
 
Posts: 34
Default Edit VBA Code without opening the workbook

Chris,

The discussion at cpearson.com is very useful and interesting and I think if
I had pursued it further it might have gotten me to where I could edit the
code at open time. I got a bit confused about exactly what he meant by 'safe
mode'. A later reply (actually two of them) offered a suggestion that was
pretty straightforward so I gave it a try and it got me to where I could edit
the code.

Thanks,

Phil

"Mark Ivey" wrote:

Here is another option you might consider...

http://www.cpearson.com/excel/StartupErrors.aspx


Mark Ivey

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

TIA,

Phil