Rename Macro

L

L. Howard Kittle

Click on the Run Macro icon in the toolbar > select the macro to rename >
Edit > delete name and rename.

or...

Right click the sheet tab to get into the VB editor. Then delete current
name of the macro and type in your own.

If the macro is not in the sheet module check out the editor tree to the
left and if there is a Module on its own double click it and check there.

Or it may be in the ThisWorkbook module right above the regular module.

HTH
Regards,
Howard
 
B

Bill Martin

Tools>Maro>Macros and select the macro you want to rename. Click on Edit. That
should take you right into the VBA editor with the macro you want to rename
displayed. Where you see: Sub MacroName() you just type in whatever name you
want used in place of the existing name. Close the editor and tell Excel to
save your file.

If that name is called anywhere else in the VBA though, you'll screw up a bunch
of links.

Bill
 
Top