Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-03-2012, 09:20 AM
namedujour
Guest
 
Posts: n/a
Default Move macros to new spreadsheet


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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving spreadsheet to Windows 7 don madsen Excel 1 09-30-2011 03:37 AM
vba Code to Print Spreadsheet to PDF OTPM Excel Programming 3 05-25-2011 08:22 AM
Move macros to new spreadsheet Creating a spreadsheet nickypatterson Excel 1 01-14-2010 03:21 PM
Move macros to new spreadsheet Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM
Move macros to new spreadsheet Spreadsheet for words Rosie Office 3 06-15-2005 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft