Excel - Run Macro when Workbook Opens - TechRepublic
General discussion
March 10, 2004 at 11:19 AM
ivy

Excel – Run Macro when Workbook Opens

by ivy . Updated 22 years, 3 months ago

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

This discussion is locked

All Comments