merging all macros into one

[Guest]

I have 6 macros in 8 worksheets (in one Excel File). They have to be executed
respectively, meaning one after one with orders.

How can i generate a new Macro to combine those 6 individual macros ?

other words: other user just click one button and all 6 macro functions are
executed respectively ?

 

[Guest]

Hi Ali,

Create one more macro that is called when the button is clicked. In this
macro put code like this:-

Call Macro1
Call Macro2
Call Macro3

and each macro will run.

Usually when I do this, I set up any Dim statements at the top of the macro
before the first sub and then they apply to all of the subroutines.

Regards,

OssieMac

 

[Gary Keramidas]

if the code is in worksheet modules instead of standard modules, you can do
something like this:

Sub run_all()
Run "sheet1.macro1"
Run "Sheet2.macro2"
Run "Sheet3.macro3"
End Sub