View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
joed joed is offline
external usenet poster
 
Posts: 7
Default VB Code stops working

I'm using Excel 2003 on an XP box. If I write a vba event handler procedure
that has any error in it, for example mismatch, out of range, whatever, ... I
stop the run, make appropriate changes but, I have to completely shutdown
excel, start it back up in order to get the procedure to run again. If I do
not do this the event handler is not called when I click on a cell, (which
fires the event).

....any suggestions, is this a setting I can change somewhere?
--
j.f.dolan