View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JH JH is offline
external usenet poster
 
Posts: 64
Default terminate a runnig macro

Thank you Tom,
but Exit Sub terminate only the procedure in which it is
and just following sub goes on
and I'need to terminate the whole macro not only one sub

Jan


"Tom Ogilvy" wrote:

if sth then
.....
else
exit sub

end if

application.quit

--
Regards,
Tom Ogilvy


"JH" wrote in message
...
hello everybody

I'd like to end a macro that is being executed

if sth then
....
else
macro would finish here

end if

application.quit
close an excel appl.
thanks

Jan