Excel Macro Question

[Guest]

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!

 

[Guest]

Put something like this in ThisWorkbook code:

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