Excel hangs upon VBA error

  • Thread starter Thread starter H. L. Greene
  • Start date Start date
H

H. L. Greene

This happens primarily during the design/programming
stage. A VBA subroutine has a compile error when trying to
run the sub. EXCEL then hangs with the hour glass
visible. I have tried everything I know to re-activate the
excel workbook so I can fix the VBA problem, save the file
and continue on. It is probably something simple since I
am making this hard to solve.
My only solution is to Ctrl_Alt_Delete. Unfortunately,
all changes in the code will be lost.
I have set up error handling code but some of this stuff
evidently cannot be captured and it fails anyway.
Any suggestions?
 
Back
Top