Put the code in the Workbook_Open event in the Thisworkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kanye" wrote in message
...
I'd like to set a macro so that when the file is opened, it automatically
runs.