Excel Macro Question

E

EA

Does anyone know how I can have Excel execute a macro whenever the Excel file
is open? It needs to be automated and not prompt the user if they would like
to execute the macro.

Thanks!
 
G

Gary''s Student

Put something like this in ThisWorkbook code:

Private Sub Workbook_Open()
MsgBox ("hello user")
End Sub
 
Top