View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike Iacovou Mike Iacovou is offline
external usenet poster
 
Posts: 32
Default 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