Rename Macro
 

Hi,
How can I rename a macro in Excel 97?
Thanks

Rename Macro
 

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

"rmpete" wrote in message
...
Hi,
How can I rename a macro in Excel 97?
Thanks

Rename Macro
 

ToolsMaroMacros 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
----------------------------------
rmpete wrote:
Hi,
How can I rename a macro in Excel 97?
Thanks

Rename Macro
 

Thank you, gentlemen;
it certainly is easy once you know how.
rmpete

"L. Howard Kittle" wrote:

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

"rmpete" wrote in message
...
Hi,
How can I rename a macro in Excel 97?
Thanks