View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default How to prevent a VB dialogue box appear

Hard to tell without code (for me anyway) try one of these before error and
turn back on after handling
application.DisplayAlerts=False
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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