There are two ways.
One is in the VBA editor under ThisWorkbook,
create:
Private Sub Workbook_Open()
End Sub

The other is on one of the code Modules.
Create:

Sub Auto_Open()
End Sub

Either will work.