HOW TO TURN DEBUGGER OFF

[KLZA]

Hello and thanks. Google Groups are the bestestest...

Is there any code I can add to VBA or macro to turn off the debugger?
Basically I have a form that on error pops up the debugger even the I
have the On error code to pop up a message on error. Thanks in
advance..

 

[Gary Keramidas]

in my opinion, you could post your code and then the code to turn off the
debugger would be a fix to your code. someone here is bound to help.

 

[George Nicholson]

If code is running so is the debugger.

Afaik, the only way to turn off the debugger is to set Security to medium
and then answer NO to the "do you want to run macros' prompt.

Post your code and lets see if we can find a better way to handle the error.

HTH,

 

[Jim Thomlinson]

Your issue is not the debugger popping up but rather that you end up with an
unhandled error (as others have pointed out). Chances are that what is
happening is that when you generate your first error you enter your error
handler. This means that you are now operating in error mode and any errors
generated will be unhandled. The way to get out of error mode is to add a
resume, resumenext or err.clear statement to your code. That being said post
what you have and we can comment further...