I'm working on a spreadsheet in Excel 2007 that is going to be shared by many users. To keep users from modifying the main copy of the spreadsheet, I put a password to modify on it.

The problem I'm having is that I put a button on the spreadsheet that executes a macro. But whenever a user saves a copy of the spreadsheet, the button seems to reference an absolute path to the macro, i.e. it always references the version of the macro in the original version of the spreadsheet. I can't rely on absolute paths and I want the button to always reference the macro on the copy of the spreadsheet being worked on. I tried creating a new button, creating a new macro with the button, and copying my code under the new button, but no luck. Anyone have any idea how to fix this?