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/