Microsoft KB Archive/124331

{|
 * width="100%"|

XL5: Err Msg: Running Auto_Open from Shortcut Key

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SYMPTOMS
When you use Microsoft Excel version 5.0 for Windows, you may receive the following error message

Cannot find macro 'WORKBOOK_NAME![MODULE_NAME].Auto_Open'

where WORKBOOK_NAME is the name of the workbook, MODULE_NAME is the name of the module sheet, and Auto_Open is the name of the sub routine.

CAUSE
This error message is displayed if all of the following conditions are true:


 * The Auto_Open subroutine is a Visual Basic, Applications Edition, macro
 * The Auto_Open macro has been assigned a shortcut key
 * The Auto_Open module is being run by using the shortcut key

WORKAROUND
To avoid this error message, run the Auto_Open module by choosing Macro from the Tools menu, or assign it to a menu item or toolbar button.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c for Windows.

Additional query words: 5.00a Crtl+key control hot key

Keywords : xlwin

Version : 5.00

Platform : WINDOWS

Issue type :

Technology :