None of these techniques are particularly elegant, and you wouldn’t want to email a file with a few macros to a colleague and tell them, “Okay, go to the Tools menu, select Macro, then select Macro, then click on MyFirstMacro in the list, and click Run.” It would be nice to just tell them, “Click the First Macro button.”
Shortcut Key combo Alt+F8, select the Macro, and click Run.Tools menu > Macro > Macros, select the Macro, and click Run.In recent posts, I’ve discussed recording macros, fixing recorded macros, and even using someone else’s macros.