Application on error sub possible ?

[Guest]

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

 

[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

 

[Guest]

Many thanks Frank. I'll try that out... I'm sure it will work perfectly