Application on error sub possible ?

M

Mike Iacovou

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
 
F

Frank Kabel

Hi
maybe something like
sub foo()
application.Visible = False
on error goto errhandler
'your code
exit sub

errhandler:
application.Visible = True
end sub
 
Top