View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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