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