Goto ToolsMacroMacros...
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" wrote in message
...
Greetings MVPs!

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