Run automated macros

[ledzepe]

Hi everyone,

How do you run a macro automatically when you open up an Excel file?

Thanks in advance.

[Excelenator]

Place the name of your macro in the This Workbook object in the Workbook_Open event.

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