Hi, I made a macro with name "Yellow" in a excel file named file1. Then, I add this Yellow macro to Quick Access Toolbar and automatically it worked for other excel files. After some days, I changed the name of file1 to filex. After that the Yellow macro does not work anyway. It shows an error and says: "Sorry we could not find file1. It is possible it moved or deleted or renamed?"

1) Why macros do not work after deleting, renaming or moving the source file, which we define them in it?

2) Is there any way to solve this problem? Can we define macros in a way to not misworking after deleting, renaming or moving the source file?



Thanks for any help.