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.

Because if you define the file as one thing, then change it to something else, how is the macro supposed to know? The only file a macro can work out file names & paths for after they've been changed is the file containing it. Even then, if you change a worksheet name, position in the file, add or delete a worksheet, that could break a macro. It is up to you to maintain the code so that it works in such cases.
Sure, but you have to code the macro to do what you want it to under such circumstances.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Because the QAT contains a full path to the file containing the code and that is not updated when you rename the file.

Yes - don't use the QAT. Customise the Ribbon using the CustomUI part of the workbook. That way all the customisation is stored in the workbook itself, not in a separate file as it is with the QAT.

Thank you so much macropod and Debaser!

Would you please explain this way more. I am a newcomer and do not know much. I can work with macro only with clicking on Record Macro and Stop Macro! I do not know what is QAT and about programming in excel. I do not want to waste your time so much. If you say some notes I will navigate about them and find the solution.

Thanks again.

I don't think the QAT (Quick Access Toolbar) is particularly relevant here - it only comes into play if you attach a macro to it.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you macropod! I got what is QAT

Would you please explain what is Ribben, CustomUI and workbook? I think if you explain these, you will solve my problem. Thanks a lot.

You really shouldn't need anyone to explain what the Ribbon is or what a workbook is. They're standard terms and you cannot use Excel without them. I suggest you do a web search on these terms...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you so much. Bless U.

Would you please more? How can code macro to ...?

I suggest you read this site: http://www.rondebruin.nl/win/section2.htm

Thank you, I read your proposed link and I got it. Thank you all and sorry to waste your time and bother you. Thanks again