macro help

[wamstrdad]

Can you provide help on the VBA code to run multiple macros from a single
"super macro"? In other words, what is the code for a macro named XYZ to run
macros the macros named ABD, DEF and GHI?

 

[Mike H]

perhaps

Sub supermacro()
MsgBox "supermacro"
abd
def
ghi
MsgBox "and back to supermacro"
End Sub

Sub abd()
MsgBox "Abd"
End Sub

Sub def()
MsgBox "def"
End Sub

Sub ghi()
MsgBox "ghi"
End Sub


Mike

 

[Dave Peterson]

Option Explicit
Sub XYZ()
call abd
call def
call ghi
end sub