Automatic Macros


Posted by NH on February 01, 2002 1:01 PM

How can I code a macro to run automatically whenever that spreadsheet is opened?



Posted by Richard Winfield on February 01, 2002 2:32 PM

Name the macro AutoOpen. If you want it to run when the sheet is selected then put the macro under the WorksheetActivate. If you want it to run when the workbook is opened then put it under WorkbookOpen.

Rick