software

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

Click on the Run Macro icon in the toolbar gt; select the macro to rename gt;
Edit gt; 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

quot;rmpetequot; gt; wrote in message
...
gt; Hi,
gt; How can I rename a macro in Excel 97?
gt; Thanks
Toolsgt;Marogt;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
----------------------------------
rmpete wrote:
gt; Hi,
gt; How can I rename a macro in Excel 97?
gt; Thanks

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

quot;L. Howard Kittlequot; wrote:

gt; Click on the Run Macro icon in the toolbar gt; select the macro to rename gt;
gt; Edit gt; delete name and rename.
gt;
gt; or...
gt;
gt; Right click the sheet tab to get into the VB editor. Then delete current
gt; name of the macro and type in your own.
gt;
gt; If the macro is not in the sheet module check out the editor tree to the
gt; left and if there is a Module on its own double click it and check there.
gt;
gt; Or it may be in the ThisWorkbook module right above the regular module.
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;rmpetequot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; How can I rename a macro in Excel 97?
gt; gt; Thanks
gt;
gt;
gt;