How to Change a Name of a Macro

Save

Microsoft Office is a suite of productivity applications that enable users to create documents, spreadsheets, presentations and more. Each application in the suite can be automated by using Visual Basic for Applications, or VBA, to write special programs that you can execute automatically or at the touch of a button. Those special programs are called Macros. You may begin writing a macro, and then realize when you are done that the name doesn't quite describe what the macro does. In that case, you can change the name of the macro.

  • Click the "Office" button in the top left corner of the program window.

  • Click "... Options" near the bottom of the menu, where the "..." is the name of the application you're running, like "Word" or "Excel."

  • Click "Customize," then click "Macros" in the "Choose Commands From" list.

  • Click the name of the macro you want to change, then click "Add >>" to add it to the list on the right.

  • Click the "Modify" button directly under the list on the right.

  • Type the name you want your macro to have in the "Display name" text box.

  • Click "OK" twice to exit the Options dialog and begin using your renamed macro.

Tips & Warnings

  • You can also change the icon for the macro that will appear if you add the macro button to a menu using the "Modify Macro" dialog where you changed the name.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!