Sub MasterMacro()
macro1
macro2 "abcd", 3
macro3
End sub

Sub Macro1()
msgbox "In macro1"
End Sub

Sub Macro2( sStr as String, lngNum as Long)
msgbox "In macro2 with args: " & sStr & ", " & lngNum
End Sub

Sub Macro3()
msgbox "In macro3"
End sub

So you just put the name (and arguments) of the macro you want to call/run
in the calling procedure.

--
Regards,
Tom Ogilvy

Stu wrote in message
...
Hi people,
I need a macro to open multiple macros when it is ran. Any ideas ?(by
the way, Im not very experienced with macros as you might be able to
tell).

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/