Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application on error sub possible ?
Hi all,
Many thanks in anticipation. I have some VBA running with application.Visible = False . While everything works fine, and errors are unlikely - they are still possible. Is there a means of setting a global "on error" command such that the application will be made visible again - otherwise it will stall invisibly. Many thanks :) Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application on error sub possible ?
Hi
maybe something like sub foo() application.Visible = False on error goto errhandler 'your code exit sub errhandler: application.Visible = True end sub -- Regards Frank Kabel Frankfurt, Germany Mike Iacovou wrote: Hi all, Many thanks in anticipation. I have some VBA running with application.Visible = False . While everything works fine, and errors are unlikely - they are still possible. Is there a means of setting a global "on error" command such that the application will be made visible again - otherwise it will stall invisibly. Many thanks :) Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application on error sub possible ?
Many thanks Frank. I'll try that out... I'm sure it will work perfectly ;)
"Frank Kabel" wrote: Hi maybe something like sub foo() application.Visible = False on error goto errhandler 'your code exit sub errhandler: application.Visible = True end sub -- Regards Frank Kabel Frankfurt, Germany Mike Iacovou wrote: Hi all, Many thanks in anticipation. I have some VBA running with application.Visible = False . While everything works fine, and errors are unlikely - they are still possible. Is there a means of setting a global "on error" command such that the application will be made visible again - otherwise it will stall invisibly. Many thanks :) Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application error | New Users to Excel | |||
application error | Excel Discussion (Misc queries) | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
Help! Application Error _< | Excel Programming | |||
Runtime Error 1004 -- Application Defined or Object Defined Error | Excel Programming |