How to run a macro automatically when i open my excel spreadsheet
 

Please put some light on this

Thanks,Harinath

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

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