Auto start a macro

[Victor Lin]

I would like to find out how to auto start a macro when I
open a Excel file

Victor

 

[Myrna Larson]

Put it in the Workbook_Open event in the ThisWorkbook module.

 

[Larry Daugherty]

In the workbook:

Option Explicit

================
Private Sub Workbook_Open()

FirstSheet = True
Application.Run ("Main")

End Sub

 

[JustDucky]

i'm not sure..
but can't you just name the macro "Auto_Open" and it will start upo
opening the file