Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Use the Workbook_Open event:
Sub Workbook_Open() MyMacro End Sub where MyMacro is the name of the macro you wish to run. To use, press ALT+F11 and place the macro in "ThisWorkbook" module. HTH Jason Atlanta, GA -----Original Message----- Hello, It is possible to run a VBA macro automatically when I open a workbook instead of opening the workbook and then run the VBA macro from the menu "Tools" "Macro?" Thanks, . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running a macro at a certain time | Excel Discussion (Misc queries) | |||
running macro at automatic time intervals | Excel Worksheet Functions | |||
Shadows of the Pivottable Field List while macro is running | Excel Worksheet Functions | |||
Running VBA Macro | Excel Discussion (Misc queries) | |||
running totals in a macro for each month | Excel Worksheet Functions |