| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Workbook automatically (by design) runs a macro
Paul,
You can name the macro to be run Auto_Open, or you can use the Workbook_Open event procedure in the ThisWorkbook code module: Private Sub Workbook_Open() ' your code here End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Paul" wrote in message ... How do I set an Excel Workbook to run a macro when the workbook is open? Thx Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
| cannot get my excel personal macro workbook to load automatically | Excel Discussion (Misc queries) | |||
| Macro that runs when worksheet is automatically updated | Excel Worksheet Functions | |||
| Open Workbook created in Excel 2003 in a computer that runs Excel | Excel Discussion (Misc queries) | |||
| One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
Linear Mode
