Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 Automatic Macros
Is there a way to have a macro run automatically when a
workbook is opened, or is such a feature unavailable for security reasons? Thanks, CM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 Automatic Macros
Here's a response from John Wilson in an earlier post
today: Two ways..... 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 -----Original Message----- Is there a way to have a macro run automatically when a workbook is opened, or is such a feature unavailable for security reasons? Thanks, CM . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (2002) slow after deleting some macros | Excel Discussion (Misc queries) | |||
Macros Excel 2002 updating file names | Excel Discussion (Misc queries) | |||
Macros in Excel 2002 | Excel Worksheet Functions | |||
How to enable macros and automatic calculation on Excel Viewer? | Excel Worksheet Functions | |||
Help for old macros with Excel 2002 | Excel Worksheet Functions |