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