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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
When writing a macro, you may want to fill a range of cells with different values. The easiest way to do this is to use ...
Discover MoreThe mouse wheel, by default, controls scrolling vertically through your worksheet. If you don't want the wheel to control ...
Discover MoreNeed to normalize your data in some way so that all your values are in a given format? This tip presents a number of ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-02-18 19:42:47
Tanya LeBlanc
How do I rename the file folder all my macros are saved under, currently its called "Modules", but I would like to give it a name "Maxium"
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