all macros into one..

  • Thread starter Thread starter Portroe
  • Start date Start date
P

Portroe

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
 
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)
 
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
 
No, Public is only needed if they are to be called from another module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Portroe said:
Thanks,

if they are in the same module do you need to declare them public?
Click to expand...
 
Back
Top