macros

  • Thread starter Thread starter andy_
  • Start date Start date
A

andy_

Hi,

I have recorded a number of macros in a worksheet,
How can i combine these macros together, instead of running each macro
i want to just run one macro.
It was too big of a job to record one big macro.

Thanks
 
Create a new procedure in any of the existing modules you may have in your
work book and just list the names of the macros you wish to run, in the order
that they are to be run in.

Sub RunEmAll()

MacroName1
MacroName2
MacroName3

End Sub

Then run your new procedure to execute them all.
 
Ok, now i have just lost my macros, It said something about
personal.xls needs to be open in the startup, but cant find it.....
 
Create a new procedure in any of the existing modules you may have in your
work book and just list the names of the macros you wish to run, in the order
that they are to be run in.

Sub RunEmAll()

MacroName1
MacroName2
MacroName3

End Sub

Then run your new procedure to execute them all.
Click to expand...

How do you refer to macros in a different module and or .xls file
 
Back
Top