Run Macros When Spreadsheet is Open

[Guest]

I would like to run macros date_check and date_close when the spreadsheet is
first open.

Please help me complete this task.

Thanks,

 

[Guest]

Joe K

Place this code in the ThisWorkbook code module.

Sub Auto_Open()

date_check
date_Close

End Sub

 

[Leith Ross]

I would like to run macros date_check and date_close when the spreadsheet is
first open.

Please help me complete this task.

Thanks,

Hello Joe,

Place your macros in either the Workbook_Open event procedure, or the
Auto_Open procedure. If you need to activate a given sheet as well for
your macro to run then include add the appropriate Sheet names to the
procedures as well.

Sub Auto_Open()
'Sheets("Sheet1").Activate
date_check
date_Close
End Sub

Sub Wokrbook_Open()
'Sheets("Sheet1").Activate
date_check
date_close
End Sub

Sincerely,
Leith Ross