Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Run Macro
Helo,
Can any body tell me how can a macro be executed automatically when ever i open a workbook. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Run Macro
Hi,
Put whatever code you wish to run inside a Sub called Auto_Open and it will be run whenever the workbook is opened. eg. Sub Auto_Open MsgBox("This message will appear as soon as this workbook has opened!!") End Sub -----Original Message----- Helo, Can any body tell me how can a macro be executed automatically when ever i open a workbook. Thanks in advance . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Run Macro
The Workbook_Open() method should do the trick.
-----Original Message----- Helo, Can any body tell me how can a macro be executed automatically when ever i open a workbook. Thanks in advance . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Run Macro
Just some added info:
Note that Workbook_Open is a workbook level event and should be placed in the ThisWorkbook module of the workbook rather than a sheet module or a general module. Go into the VBE (alt+F11) and look in the project explorer (Ctrl+R if it isn't visible). Find your workbook in the "tree" and look for the ThisWorkbook entry under that. Double click on ThisWorkbook and the thisworkbook module will open. In the left dropdown at the top select Workbook and in the right dropdown, select open. It will put in the skeleton declaration for the Open Event Private Sub Workbook_Open() End Sub put your code in that declaration or call it from that declaration. -- Regards, Tom Ogilvy "Lieven Roelens" wrote in message ... The Workbook_Open() method should do the trick. -----Original Message----- Helo, Can any body tell me how can a macro be executed automatically when ever i open a workbook. Thanks in advance . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |