Use the Workbook_Open Event in the ThisWorkbook module.

See Chip Pearson's page on events for an explanation

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

--
Regards,
Tom Ogilvy

"psk" wrote in message
...

Hi ,
I am new to the macros and also with excel .I need to know how to
run the macros automatically while opeing the excelsheet ..Can anyone
tell me ..?



Thanks


--
psk
------------------------------------------------------------------------
psk's Profile:
http://www.excelforum.com/member.php...o&userid=15738
View this thread: http://www.excelforum.com/showthread...hreadid=273180