Excel hangs upon VBA error

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top