Auto start a macro

V

Victor Lin

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

Victor
 
L

Larry Daugherty

In the workbook:

Option Explicit

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

FirstSheet = True
Application.Run ("Main")

End Sub
 
J

JustDucky

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