Macro stops after I dismiss run-time error dialog

G

Gregg Roberts

Using Excel 2007, writing a macro and trying to debug it. When any run-time
error occurs and I dismiss it, the macro instantly stops. I used to be able
to see the problem code line highlighted in yellow, fix the problem, and
resume stepping through the macro. It did not happen the last time I wrote
and debugged a macro on the same machine, AND it happens on a co-workers'
machine also on this macro.

I have heard that MS now downloads and installs updates without always
telling us. If that's true, it's possible that a buggy update to Excel was
installed on both our machines. Excel version number is 12.0.6024.5000.
 
G

Gregg Roberts

Somehow in Tools > Options > General, "Break on All Errors" got changed to
"Break on Unhandled Errors". Changing it back fixed the problem. Local
sysadmin helped me find this.
 

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

Similar Threads

Excel crashes when running a Macro 0
Excel will run a macro only after unplugging pc from the network 1
"Reference not Valid" error in the macro dialog box 1
Path/File Access Close this error then Run-time '75' Error 0
run-time error 1004 exiting Excel 2007 2
Run time Error 1004, on shared workbook 2
Excel freezes after I insert a new row 0
Macro stops for no reason 4

Top