Err Msg:"Cannot Find Macro" Running Macro from Object
Article ID: 116280
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q116280
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>
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 XL
Keywords: kbprogramming kbprb KB116280