execute a macro from another macro

[joao]

hi,

how do i execute a macro fron another macro? They are in the same
workbook, but in different worksheets!

Thanks

 

[Tom Ogilvy]

Sub MyMacro()
Sheet1.OtherMacro
End Sub

 

[Jim Rech]

Macros on different modules of the same workbook are called exactly as if
they were in the same module - by their names:

In Module1:

Sub CallMod2Sub()
Mod2Sub
End Sub

In Module2:

Sub Mod2Sub()
MsgBox "Hello from Module2"
End Sub

 

[KM]

Just put the name of the macro

Call macroname

regards
Km