Stop Execution of Macro

[seekeagle]

I am aware that the execution of a macro can be stopped with the statement "Exit Sub". However, that only returns control the the calling subroutine. How do I completely stop execution of the entire macro?

 

[hiker95]

seekeagle,

Try:
Press and hold down the "CTRL" key, and press the "Break" key.

 

[jbeaucaire]

If you mean "how do I abort the whole macro from inside a subroutine?"

I've never done that, but I imagine declaring a Public variable at the start of the main macro would set the stage for being able to do it:

Public AbortMe as Boolean
AbortMe = False

call SubMacro

If AbortMe = True Then Exit Sub

macro continues...

Then within the subroutine, if something happens that requires the subroutine to not only quit, but to also signal to the parent macro to stop, too, then set the AbortMe flag before exiting:

Sub SubMacro()

'macro does some stuff

If SomethingBadHappened = True Then
    AbortMe = True
    Exit Sub
Else
'    Do other stuff
End If
End Sub

You get the idea.

 

[Trebor76]

Hi seekeagle,

Try using the VBA command "End" in the applicable section of you code.

HTH

Robert

 

[seekeagle]

The End statement works fine. I was trying to Stop, End Macro, End Sub, etc. Any all I needed was "End".

Thanks,