My dept. just migrated to 2010 and we had a master Excel 2003 file that contain dozens of macros that are tied to a toolbar that we previously "attached" to all open Excel spreadsheets opened on a users pc. It seems like the last developer updated a few of the macros in this master file and this was done in a different system folder than the macro was used to running. Long story short, when a user selects an option on the custom toolbar, the button could potentially be looking for two different master file locations. I know how to change this path in 2003, but I'm unable to do this in 2010. (and placing this master file in both locations is not a viable option).
If anyone has dealt with this, please let me know.