Excel Macro Question
 

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!

Excel Macro Question
 

Put something like this in ThisWorkbook code:

Private Sub Workbook_Open()
MsgBox ("hello user")
End Sub
--
Gary''s Student
gsnu200708


"EA" wrote:

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!