View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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