To assign your macro to this button, double-click your CommandButton, and insert your desired VBA code. The end result is a highly customizable button that allows for more advanced programming.

The first is picking the macro you want to use from the menu, which is a bit complex. If you use it often, assign a macro to a button, making it easier to run. Access your Excel macros ...

A small window labeled "Macro" will appear. Click on the Excel macro that you want to run, then click the "Run" button. If you want to assign the macro to a hotkey, click the "Options" button.

A: You will want to write a macro in Word to accomplish this. If you use the macro often, you'll probably want to assign the macro to a button in Word. Just follow these steps: ...

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.