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