You can put this in the workbook module:

Private Sub Workbook_Open()
    'your code here
End Sub

or you can put this in a standard module:

Sub Auto_open()
    'your code here
End Sub