Darn..thanks for confirming.

--
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility
Free and Pro versions

"Chip Pearson" wrote in message
...

You can't change the error handling programmatically. (Well, I suppose
it is stored somewhere in the registry, so I guess it is technically
possible.) But generally, this is a manual setting.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 21 Mar 2009 11:39:03 -0700, "Tim Zych" <tzych@nospam at
earthlink dot net wrote:

When I use error handling, it will be ignored if VBE's Error Trapping
setting is set to "Break On All Errors".

Therefore the following code would produce an error.

On Error Resume Next
Msgbox 5/0

Is there a way to programmatically set Error Trapping to "Break On
Unhandled
Errors"?

Thanks