Quote:
Originally Posted by tesoke
1) Why macros do not work after deleting, renaming or moving the source file, which we define them in it?
|
Because the QAT contains a full path to the file containing the code and that is not updated when you rename the file.
Quote:
|
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?
|
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.