Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macros When Spreadsheet is Open
I would like to run macros date_check and date_close when the spreadsheet is first open. Please help me complete this task. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macros When Spreadsheet is Open
Joe K
Place this code in the ThisWorkbook code module. Sub Auto_Open() date_check date_Close End Sub "Joe K." wrote: I would like to run macros date_check and date_close when the spreadsheet is first open. Please help me complete this task. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macros When Spreadsheet is Open
On Oct 16, 7:22 pm, Joe K. <Joe wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet will not open without Excel Application being open fir | Excel Discussion (Misc queries) | |||
How to open a spreadsheet with Macros disabled | Excel Discussion (Misc queries) | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |