Recorded macro: What happens if I change filename?
Hi everyone,
Say I have a recorded macro named "Base" and linked it to a button in a
an excel workbook named ABC.xls
Later, say I changed the file name to DEF.xls
Now, when I click on the button to execute, I get "out of range"
error and the file close!
How can I make the macro name is independent of the file name; so it
doesn't keep referring to the old file name?
Regards,
Mike
|