1,105,221 Community Members

Excel 2010 Customize Ribbon

Member Avatar
Vaspar
Light Poster
47 posts since Feb 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

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

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article