XL: Err Msg:"Cannot Find Macro" Running Macro from Object

ID: Q116280

The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel, if you have a defined name in a workbook that is the same as a macro name on a Microsoft Visual Basic for Applications module, you may receive one of the following error messages:

Cannot find macro <name>
-or-
The macro '<name>' cannot be found.
where <name> is the name of the macro assigned to the object.


RESOLUTION

To ensure that this message does not occur, do either of the following:

  • Use unique names for macros as well as names on worksheets.


    • -or-

  • Specify the complete path to the macro, as in the following example:
    <module name>.<macro name>



MORE INFORMATION

Worksheet names or Excel 4.0 Macro sheet names take precedence over the names of macros on module sheets. Because of this order of precedence, the macro name assigned to the object is replaced with the newly defined workbook name (which is not a macro).

Additional query words: 5.00a 5.00c 7.00a macro XL5 XL7 XL97 XL98

Keywords : kbprg kbdta PgmOthr KbVBA
Version : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,7.0a,97
Platform : MACINTOSH WINDOWS
Issue type : kbprb


Last Reviewed: October 22, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.