Hi,

I think this question is asked at least twice a day, you should always
search google groups before asking (groups.google.com), that way you
would have found the answer sooner.

You must put your code inside the workbook_open event in the
ThisWorkbook code module. Either you put the code or call your macro
from there.

Private Sub Workbook_open()
'your macro
End Sub

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.