View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Error Handling

Hi Bin,

Unfortunately, no. If the user has this setting and your code depends on
something like On Error Resume Next then your code will not work on that
users computer until they change the setting.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Bin" wrote in message
...
Is there anyway in Vb Program to use a code to override
Error Trapping setting in VB/Tools/Option?
If the setting is "Break on All Error", program error
handling statement will not work.
I tried to use "On Error Goto 0" to override it, but it
doesn't work.
Anyone can help? Thanks.