Make Called Macro End the First Macro

[carsto]

Sub FirstMacro()

Code to do this or that

Call SecondMacro

Code to do this or that

End Sub

Sub SecondMacro()

IF  this is true GoTo ErrorMsg
	Then     'okay to back to First Macro
	Exit Sub

ErrorMsg:
MsgBox "Sorry, the macro is finished."     
‘at this point do not return to First Macro

End Sub

When I call a Second Macro within the First Macro
and the Second Macro ENDS with the ErrorMsg,
I don’t want to resume the FirstMacro.
How can I stop it from returning to complete the First Macro?

TIA
you guys are awesome, I have learned so much here
more than all my books combined

[funkymonkUK]

why not try pass a value between the two.

sub test1()

dim macroerror as string

macroerror =""

macroerror = SecondMacro (macroerror)

if macroerror <> "" then exit sub
end sub

Sub SecondMacro(macroerror as string)

IF this is true GoTo ErrorMsg
Then 'okay to back to First Macro
Exit Sub

ErrorMsg:
macroerror = "Yes"
MsgBox "Sorry, the macro is finished."
‘at this point do not return to First Macro

End Sub