To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stefi" wrote in message
...
Call it from Workbook_open event macro!

Regards,
Stefi


"rexmann" ezt írta:

Hi all

sorry if this should go in programming but does anyone know how to set
it up
so a macro runs when you open excel? Any help greatly appreciated

Kind regards

Gareth Rexworthy