Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate macro
Hi,
Is it possible to have a macro run automatically when a particular spreadsheet opens? I'm in Excel 2000 and Windows 98. Thanks, Marc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate macro
Marc,
Two ways..... 1st is to name your macro Auto_Open Sub Auto_Open() 'your code here or your sub name here End Sub or place your code (or a call to your sub) in the Workbook_Open Event Double click on the "ThisWorkbook" in the "Projects" window and copy and paste the following: Private Sub Workbook_Open() 'your code here or your sub name here End Sub John Marc wrote: Hi, Is it possible to have a macro run automatically when a particular spreadsheet opens? I'm in Excel 2000 and Windows 98. Thanks, Marc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate macro
Thanks John
That worked! And thanks for such a quick response. Marc -----Original Message----- Marc, Two ways..... 1st is to name your macro Auto_Open Sub Auto_Open() 'your code here or your sub name here End Sub or place your code (or a call to your sub) in the Workbook_Open Event Double click on the "ThisWorkbook" in the "Projects" window and copy and paste the following: Private Sub Workbook_Open() 'your code here or your sub name here End Sub John Marc wrote: Hi, Is it possible to have a macro run automatically when a particular spreadsheet opens? I'm in Excel 2000 and Windows 98. Thanks, Marc . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Macro | Excel Discussion (Misc queries) | |||
Automate Macro | Excel Discussion (Misc queries) | |||
Automate Macro | Excel Discussion (Misc queries) | |||
Automate Macro | Excel Discussion (Misc queries) | |||
Automate Macro | Excel Discussion (Misc queries) |