View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default How to programmatically set Error Trapping in VBE

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