Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent a VB dialogue box appear
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent a VB dialogue box appear
The code is to open up an Access database. Sometimes the access to the server
is down and the error message will tell the user that the path can not be found and ther is a button for END and one for DEBUG. Instead I want my msgbox "Database..." show. It works fine but the VB Dialogue box opens up and it did not work with Application.DisplayAlerts=False. Is there a way to just enable just the END button? That would work too. I am working in Excel 2000. "John Bundy" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent a VB dialogue box appear
Breake on Unhandle errors is checked.
Thanks Gunilla "Tom Ogilvy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent dialogue: "save changes"? | New Users to Excel | |||
Dialogue Box | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
pop up dialogue box | New Users to Excel | |||
pop up dialogue | Excel Discussion (Misc queries) |