You can do it like this:

Code:
Private Sub Workbook_Open()

    Call Macro1

    Call macro2
    
End Sub