Updating Macro References

Okay (I'll try to be more specific)-

I built a spreadsheet (on Excel 2000) that has, attached to it, a custom toolbar. There are 12 buttons on the toolbar (January through December) that activate macros that print the tab on the spreadsheet that correspond to the buttons on the toolbar.
Here's the problem, my boss loves to take our files, and move them to new directories, or load them on disk to send to clients so they can use them. Having previously used Q-Pro, this wasn't a problem, as all the code was on the spreadsheet. Now when we move these files, when the toolbar goes to activate the macro, it tries to find it in its old location. It will change the assignment on the button bar from the simple macro name, to the macroname with the previous directories and disk drive in fromt of it. Ex-

'PrintJuly'!SpreadsheetName.xls becomes C:\Files\County\'Print!July'!Spreadsheet name.xls

Excel now tries to open the macro out of a spreadsheet that's either no longer there, or is of the same name as the one I'm already in. You see the problem. What I want to be able to do is, take my *.xls file, save it on disk, open it on another computer, and have my macros to which my custom button bar refers, work. Please help me!!