Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later 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.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2924) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Renaming a Macro.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Need to know the character code used for a particular character? In a macro you can use the Asc function to determine the ...
Discover MoreWhen you need to get rid of characters in the middle of a cell value, the best way to do it is through the use of macros. ...
Discover MoreWhen creating macros, you often have to know how to display individual worksheets. VBA provides several ways you can ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-02-27 13:06:29
On my version of MS Word 2013 I have two macros, Swap_Letter and Word_Count. They work perfectly. However, the names that appear on the HOME bar in "New Group" are "Normal.NewMacros.Swap_Letter" and "Normal.NewMacros.Word_Count" How do I get rid of the "Normal.NewMacros." so that only Swap_Letter and Word_Count are displayed on the screen as the macros' names?
2017-01-26 16:02:03
Joe Maier
Module C1_test1 exists
I tried to create ne module named C1_test2
Get error msg not allowing the creation
2017-01-09 12:17:21
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!
2015-06-08 12:15:07
David
I changed the name of a macro, now I can not find it! Any help would be great!
2015-05-07 12:02:50
Larry
I rename the module from module 1 to a different name, but now the shortcut keys that was assigned to module 1 is not working, and when I view the list of macros this macro name has had the file name added to it plus the macro name has been added again. Example: FileName.MacroName.MacroName instead of just MacroName. Does anyone have any suggestions on how to fix this problem?
2015-04-15 08:13:59
Naser
I like it, it helps.
Thanks... :)
2014-08-27 05:56:09
Willy Vanhaelen
Simply reassign the shortcut.
2014-08-26 17:23:07
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
2014-04-08 03:27:18
Andy Y
Thanks for the tip! Very helpful.
2013-08-13 03:08:11
Premchandar
Glad with your tip it is so easy
Thanks
Prem
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 
Comments