This is a similar question to what I asked here.

I'm still stuck though. I have a sheet that has a button on it that calls a macro. If I copy that sheet to a new file (and the macros that go with it), the button in the new file still points to the macro in the original file. How can I make it so when I copy the sheet, the button points to the macro within it's own file?