Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / December 2007

Tip: Looking for answers? Try searching our database.

Macro stops after I dismiss run-time error dialog

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gregg Roberts - 14 Dec 2007 20:23 GMT
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.
Signature

Gregg Roberts

Gregg Roberts - 17 Dec 2007 21:34 GMT
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.

Signature

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
[quoted text clipped - 6 lines]
> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.