View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default How to prevent a VB dialogue box appear

In the vbe go to tools=Options and under the General tab make sure you have
something other than Break on All Errors selected.

--
Regards,
Tom Ogilvy


"Gunilla G" wrote:

I have an
on Error go to Handler
xxxx
exit sub
Handler:
msgbox "Database not available"
end sub
It works but a Microsoft Visual Basic dialogue box opens with Run-time error
3709
I don't want that to happen. What am I doing wrong?
Gunilla G