View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B[_6_] Paul B[_6_] is offline
external usenet poster
 
Posts: 135
Default Macro to open multiple macros

Stu, "open multiple macros"? do you want to run them from one macro? if so
lets say you have some macros like this

Sub test1()
MsgBox "this is macro test1"
End Sub

Sub test2()
MsgBox "this is macro test2"
End Sub

Sub test3()
MsgBox "this is macro test3"
End Sub

then use something like this to run them all
Sub Run_All()
test1
test2
test3
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"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/