Posted to microsoft.public.excel.programming

Tim Zych

external usenet poster

Posts: 389

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error Trapping	gazza67[_2_]	Excel Discussion (Misc queries)	2	September 6th 07 06:11 PM
while deleting rows it finds an error - error trapping	Janis	Excel Programming	2	July 19th 07 12:12 AM
Error Trapping	JK	Excel Programming	2	March 1st 06 11:45 PM
Error Trapping	Adrian	Excel Programming	0	January 31st 05 06:16 PM
Error Trapping	Neil	Excel Programming	1	January 5th 04 04:38 PM

All times are GMT +1. The time now is 07:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us