Excel – Run Macro when Workbook Opens

I designed a timesheet program the secretary uses. She clicks on a menu option I’ve added called Format Monthly. It creates a timesheet with an employees name, etc on it. She then clicks on Mail Monthly which emails this timesheet to the employee. Before emailing it, I append a menu item to this workbook. In the older version of Excel, the macro runs when the users open the workbook. In Excel XP, it no longer runs. The user has to click on the Macros and run it. How do I get it to run automatically when the user opens the workbook.

TIA,

Ivy Harrison harrisonivya@Uams.edu