Use the Workbook_Open event in the thisworkbook.module.

See Chip Pearson's page on events for a discussion.

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

--
Regards,
Tom Ogilvy


"Aaron" wrote in message
...
Hello,

I need to run a macro when my workbook opens. Can someone please help
with
this very simple code?

Thank you much,
Aaron