Exit Sub
 

Hi,

I use "Exit Sub" to exit a sub procedure. How can you exit the entire
string of precedures?

I have Sub Macro1() - calls Sub Macro2 - calls Sub Macro3.

If I am in Macro3 and want to program to stop running I have to pass an
"exit switch" all the way to Macro1. Is there a faster way to do this?

Thanks for your help.

Exit Sub
 

I suppose that you call just stop it all

End

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jeff" wrote in message
...
Hi,

I use "Exit Sub" to exit a sub procedure. How can you exit the entire
string of precedures?

I have Sub Macro1() - calls Sub Macro2 - calls Sub Macro3.

If I am in Macro3 and want to program to stop running I have to pass an
"exit switch" all the way to Macro1. Is there a faster way to do this?

Thanks for your help.

Exit Sub
 

Wow its just that simple -

I'm surprised I've never seen that before from my readings - I also could'nt
find anything when I searched online.



"Bob Phillips" wrote:

I suppose that you call just stop it all

End

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jeff" wrote in message
...
Hi,

I use "Exit Sub" to exit a sub procedure. How can you exit the entire
string of precedures?

I have Sub Macro1() - calls Sub Macro2 - calls Sub Macro3.

If I am in Macro3 and want to program to stop running I have to pass an
"exit switch" all the way to Macro1. Is there a faster way to do this?

Thanks for your help.