In your VBA IDE in the Tools > Options > General tab > make sure "Break on unhandled errors" is selected.


Edit: woot! 27,000 Posts