| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run a macro automatically when i open my excel spreadsheet
Please put some light on this
Thanks,Harinath |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to run a macro automatically when i open my excel spreadsheet
Hi,
In the Project explorer, open the "Thisworkbook" module In the Top left dropdown of the module code window, select "Workbook" iso "Declaration". The top right dropdown gives you all the events associated with this workbook, and for wich you can have a sub. Choose the "Workbook_Open" Et voila. Regards, Jean-Yves "Harinath" wrote in message ... Please put some light on this. Thanks,Harinath |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to run a macro automatically when i open my excel spreadsheet
Hi
in addition to use the Workbook_Open event you may rename your macro Auto_Open() -- Regards Frank Kabel Frankfurt, Germany "Harinath" schrieb im Newsbeitrag ... Please put some light on this. Thanks,Harinath |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically open a specific spreadsheet when opening Excel | Setting up and Configuration of Excel | |||
| create a macro to automatically open excel | Excel Discussion (Misc queries) | |||
| Hidden rows automatically unhide when I open Excel Spreadsheet. | Excel Discussion (Misc queries) | |||
| Macro to automatically open a website or send an e-mail in excel | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
