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

--


Gary


"ali" wrote in message
...
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 ?


--
---------