rbelforti

Usually you can only run 1 macro at a time.

You can have 1 macro call another macro. but the rest of the code o
the 1st macro will not be actioned until the 2nd macro has finished

To run a macro automatically when a workbook is opened you will need
macro called Auto_Open in a normal module or you will a macro o
thisworkbook module




sub auto_Open
call Macro1
call Macro2
call Macro3
end sub



Private Sub Workbook_Open()
call Macro1
call Macro2
call Macro3
End Su

--
Message posted from http://www.ExcelForum.com