XL2000: "Cannot Find Macro" Error Message When Running Macro from Object (213463)
The information in this article applies to:
This article was previously published under Q213463 SYMPTOMS
In Microsoft Excel 2000, 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, one of the following error messages may appear
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 you don't receive this error message, do either of the following:
- Use unique names for macros as well as for names on worksheets.
-or-
- Specify the complete path to the macro, as in the following example:
MORE INFORMATION
Worksheet names take precedence over the names of macros on module sheets. Therefore, the macro name assigned to the object is replaced with the newly defined workbook name (which is not a macro).
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kberrmsg kbprb kbProgramming KB213463 |
|---|
|