Just call the second macro from Auto_Open:

Sub Auto_Open()
' your code
SecondMacro
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Dtown Dawg" wrote in
message
...
Right now I have a macro named Auto_open and as you know as
soon as excel is
opened it runs the macro. This macro copies 100 Excel
spreadsheets from one
location on the network to a different location. Works Fine.

I then have another macro that takes all those 100 spreadsheets
and combines
them into 1 spreasheet. Works Fine.

Is there a way that I can have the Auto_open macro run 1st just
like it
does, and then as soon as it finishes, have the other Macro to
merge the
spreadsheets run without the user having to acutally click on
Run Macro?

Thanks;
The Dawg