Renaming a Macro

Greetings MVPs!

I recorded a macro called Macro1. How can I rename it in VBA code? Many
thanks.

Goto Tools>Macro>Macros...
Select Macro1 from the list
Click Edit

this will take you to the window with that macro. Just change Macro1 to
whatever you want.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Excel User" <ExcelUser@discussions.microsoft.com> wrote in message
news:378AD2A1-1397-4D35-9298-81B657B73AD8@microsoft.com...
> Greetings MVPs!
>
> I recorded a macro called Macro1. How can I rename it in VBA code? Many
> thanks.