Rakesh,

Name the macro Auto_Open and it will run automatically when the
workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Rakesh" wrote in message
...
How can I get a macro to run automatically when a worksheet
containing that macro is opened?

Thanks.