Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
all macros into one..
Hi
I have a number of small macros on a table. How can I include them into obne large macr so that they all run at once, thanks portroe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
all macros into one..
Why not just have one new macro that calls them all one after the other?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Portroe" wrote in message ... Hi I have a number of small macros on a table. How can I include them into obne large macr so that they all run at once, thanks portroe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
all macros into one..
Put the code for the macros in to a module and be sure to rename them
and declare them as "Public" exe: Public Sub NewSub1() blah blahblah End Sub Public Sub NewSub2() blah blahblah End Sub Public Sub NewSub3() blah blahblah End Sub Then create one macro that calls each in turn: Sub Macro1() Call NewSub1 Call NewSub2 Call NewSub3 End Sub - Pikus --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
all macros into one..
Thanks,
if they are in the same module do you need to declare them public? pikus < wrote: Put the code for the macros in to a module and be sure to rename them and declare them as "Public" exe: Public Sub NewSub1() blah blahblah End Sub Public Sub NewSub2() blah blahblah End Sub Public Sub NewSub3() blah blahblah End Sub Then create one macro that calls each in turn: Sub Macro1() Call NewSub1 Call NewSub2 Call NewSub3 End Sub - Pikus --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |