Auto_Open Macro Not Working Correctly on Excel Worksheet (28189)

SUMMARY

To create a macro that runs automatically every time you open a particular Excel document, do the following:

Microsoft Excel version 5.0 and later

1. Open the workbook from which you want to run your macro. Select either a worksheet or macro sheet tab.
2. On the sheet, define the name Auto_Open that refers to the macro that you want to run, as in the following examples:

   =My_Macro (My_Macro located in same workbook)
   
   -or-
   
   =BOOK2.XLS!My_Macro (My_Macro located in separate workbook)

   Note that My_Macro may be either a Visual Basic macro or a Microsoft Excel 4.0 macro.
3. Close and save the workbook.

Microsoft Excel versions 2.x, 3.0, 4.0

1. Open both your worksheet and your macro sheet.
2. On your worksheet, define your Auto_Open macro with a reference to the open macro sheet, as in the following example:

   =test.xlm!my_macro

3. Close the macro sheet.
4. Save the worksheet.

The Auto_Open macro now runs correctly when you open the worksheet.