Automating Macros

Posted by Pavan Kondur on November 01, 2001 6:15 AM

How do I automatically make excel run a macro when i open excel.

Your Help is greatly appreciated.

Thanks

Posted by Todd on November 01, 2001 6:18 AM

In the VBA project window, click on this workbook. In the left of the two drop down box windows at the top of your screen, select Workbook. The Open action macro should pop up. Type code in there, or refer to your macro in there.

Posted by Andrew Cheung on November 01, 2001 7:22 AM

You can change the name of your Macro to
Sub AutoOpen and the macro will run automatically when you open the workbook with the macro AutoOpen