Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Renaming a Macro.
A macro is nothing more than a series of instructions you want the computer to execute. It is a program which is run in the context of the application you are using. As you create macros, you will probably come across a need to rename a few of the existing macros. To do this, follow these steps:
Remember that if you rename a macro, you may need to make other changes, as well. For instance, if you have the macro referenced (called) from a different macro, you'll need to change that other macro to reflect the name as you just changed it. If the macro is also referenced in toolbar buttons or in menus, you'll need to make changes in those to reflect the new name, as well.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12428) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Renaming a Macro.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Having problems with using macros in a protected workbook? There could be any number of causes (and solutions) as described ...
Discover MoreWhen you use a macro to do file operations, it works (by default) within the current directory. If you want to know which ...
Discover MoreDo you need to know how many times a worksheet has been used? Excel doesn't track that information, but you can develop some ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-01-09 12:18:43
DID
Re: After renaming a module, shortcuts do not work... answer to this problem...
>>>It looks like you gave your module the same name as the macro. If you did then that is the problem. This will confuse the VBA compiler. I will use underscores in my module names (spaces are not allowed) so I know what the macro is but not confuse VBA.
For example, I would name the module CGM_Formatting_WIRELINE and the macro name would be CGMFormattingWIRELINE. Change the name, resave the file, and you should be okay.<<<
http://www.mrexcel.com/forum/excel-questions/568764-visual-basic-applications-module-name.html
This solved my problem(S) that have been going on for a long time and I could not find the answer!
2014-12-20 06:34:58
Willy Vanhaelen
There will probably be an illegal character in the new name such as a space.
Go back to the the VBA editor (press Alt+F11) and correct.
2014-12-18 09:41:50
Kathy
I renamed my macro and closed visual basic. macro is not in my list of macros. where is it?
I didn't save anything; just closed visual basic like the instructions said. can i get it back?
2014-08-27 10:39:24
Willy Vanhaelen
Simply reassign the shortcut.
2014-08-26 17:27:36
I am having the similar issue
I rename the module from module 1 to a different name, but now the shortcut that was assisgnged to module 1 is not working, how to I fix it
Any suggesstions
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2017 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments