Macro to run when sheet opens
 

Hi
do you mean the worksheet or the workbook? In both cases you need an
event procedure
worksheet: worbook event: workbook_sheetactivate
workbook: workbook event: workbook_open()

See: http://www.cpearson.com/excel/events.htm


--
Regards
Frank Kabel
Frankfurt, Germany


Rakesh wrote:
How can I get a macro to run automatically when a worksheet
containing that macro is opened?

Thanks.