Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to run a macro automatically when the file is opened?
Hi all,
I often have to click a macro button after opening an Excel 2003 workbook... Is there a way to open the file and automatically run the macro immediately after opening the file without me sitting there and click and waiting? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to run a macro automatically when the file is opened?
This may work--but it depends on what that other macro does and what kind of
button you click on to run it. You could create a new macro in a General module: Option Explicit Sub Auto_Open() call YourExistingMacroNameGoesHere end sub LunaMoon wrote: Hi all, I often have to click a macro button after opening an Excel 2003 workbook... Is there a way to open the file and automatically run the macro immediately after opening the file without me sitting there and click and waiting? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill color of cells automatically change when file is opened | Excel Discussion (Misc queries) | |||
A macro that counts the number of times a file is opened | Excel Discussion (Misc queries) | |||
How to auto activate macro when file opened | Excel Worksheet Functions | |||
How can a macro automatically initiate uponing a file? | Excel Discussion (Misc queries) | |||
Automatically launch a macro when a fil is opened | Excel Discussion (Misc queries) |