Stu,

Either name the macro Auto_Open and put it in a normal code module (old way)
or put it in Worksheet_Open event code in ThisWorkbook code module (new
way).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/