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....