Place the name of your macro in the This Workbook object in th
Workbook_Open event.
To do this right click the excel icon next to the File menu command an
select view code. Select Workbook from the drop down box at the to
middle of the VBE. The Workbook_Open even macro code will be inserte
and you can paste your code there. Save the workbook and close it an
the next time you open it the code will execute
