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!
