I'm looking for a bulk method or macro to help me fix the Macro name path assigned to my custom buttons. Whenever I get a new computer or have to move my personal.xls file, I have to manually re-assign each of my custom button macros one at a time.
Well, I didn't do it intentionally and I don't really know what happened the other day while I was writing a macro, but now all of my custom buttons are no longer "assigned" to the personal.xls file but are looking for another file I had been working on. (similar to when you move a personal.xls to another computer) Is there a way to fix the assignment, without having to fix each one manually, so that the path points back to my personal.xls? Thanks in advance....
Well, I didn't do it intentionally and I don't really know what happened the other day while I was writing a macro, but now all of my custom buttons are no longer "assigned" to the personal.xls file but are looking for another file I had been working on. (similar to when you move a personal.xls to another computer) Is there a way to fix the assignment, without having to fix each one manually, so that the path points back to my personal.xls? Thanks in advance....
Last edited:
