Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error: The macro "macro name" cannot be found

Status
Not open for further replies.

rmo87

Programmer
Aug 8, 2007
3
US

I have an Excel document with a macro that refers to another spreadsheet that contains a created button (gray box), which in turn runs a macro when clicked.

I am trying to create a second version of these two spreadsheets with slight modifications.

The first macro runs OK, but I receive the following when Excel attempts to run the second macro: Run-time error '1004': The macro "full name here including the name and location of file" cannot be found.

If I then click 'Debug', it takes me to a line in Visual Basic highlighted in yellow: Application.Run "ABC.xls!macroname"

How do I get it to refer to the macro properly?
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top