I've created a new 2012 .xlsm spreadsheet with data from the 2011 .xlsm spreadsheet. The macro buttons on the toolbar work, but only because they open up last year's spreadsheet and run from there. The hot keys do NOT work unless the old spreadsheet is open.

I went to the Developer tab and tried to edit them by renaming them "2012" but the new name didn't stick. I don't want to re-record everything. Is there a way to simply move the macros to another worksheet and have everything work?

I tried copy/pasting the VB code from one spreadsheet to the other, and that didn't seem to work.