execute a macro from another macro
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
--
Jim Rech
Excel MVP
|