how do you change the name of a macro

Dear Mehul

Thank you for attending the Excel Advanced Course. I hope you enjoyed it.

Once you have created the macro and decide to make amendments you have to use the visual basic Editor to do that.

Please follow these steps to achieve that.

Step 1: Please make sure that you open the file that contains the macro you need to modify.

Step 2: Choose Tools > Macro > Visual Basic Editor or (ALT_F11)

Step 3: You’ll notice a new window appear on the screen.

Step 4: On the left hand side you’ll see a Project Explorer window showing the VBAProject (name of the workbook) . If you don’t see this then you can choose View > Project Explorer.
When you have a macro created in a workbook you can see a folder called Modules just after the Sheet 1, 2 and 3.

Step 5: Double-click on the Modules Folder and then double-click on Module 1. You’ll notice some coding on the right hand window.

Step 6: The very first line should say Sub and the “Macro name that you assigned”. Change it to that name of your choice (please remember to use the underscore if you have more then one word in the name.). You’ll also notice that just below the name that you modified the name there will be the old Macro name in green colour. Please change that exactly to the same new name and then press the save button.

If this reply has helped answering your query then I would request you to please mark this question as resolved. If not then you can either reply back to this question for further explanation or post a new question the forum.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003