I have been creating Macros and then adding them to the customized ribbons on excel (2010). The problem I have is that each time I rename the original file (save as) that i created the macros and ribbon in and then click on the ribbon/macro it automatically opens up the original file for it to work on the new save as file. if i remove file from original path and then open again the renamed file and run macro using ribbon it doesn't run it gives me error file not found.

i have exported customized ribbon ui and when i open it using notepad++ i can see hardcoded paths of original file
is there anyway to resolve this?? to rename those ribbons everytime i save file with different name or at different path....

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.