ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Renaming a Macro (https://www.excelbanter.com/excel-programming/351972-renaming-macro.html)

Excel User

Renaming a Macro
 
Greetings MVPs!

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

Bob Phillips[_6_]

Renaming a Macro
 
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.





All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com