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


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

I *think* this is what you're driving at.

On Error Resume Next
MsgBox 5 / 0
If Err < 0 Then
MsgBox ("Error:= " & Err)
End If
On Error GoTo 0



"Tim Zych" 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


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

Barb,

if you set up an environment as I explained, you should see part of the
problem.


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

"Barb Reinhardt" wrote in message
...
I *think* this is what you're driving at.

On Error Resume Next
MsgBox 5 / 0
If Err < 0 Then
MsgBox ("Error:= " & Err)
End If
On Error GoTo 0



"Tim Zych" 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


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

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

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