How to Add a Button to a Macro
A prerecorded macro, saved to the macros library, can be assigned to a button in the Microsoft Office Quick Access toolbar. When a macro has been assigned to a button in the Quick Access toolbar, you can 'run' or execute the macro by...
Method 1 of 2:
Add a Macro to a Toolbar in Microsoft Office
- Assign a preexisting macro, saved to the macro library, to a button in the Quick Access toolbar.
- Open a new document and click the "Office" button in the upper-left corner of the application window.
- Click "Word options" located at the bottom of the pull-down menu. The Word options dialogue box will open.
- Click the "Customize" button, located in the column on the left, to display the "Customize the Quick Access Toolbar and keyboard shortcuts" dialogue box.
- Select Macros from the "Choose commands" menu located above the column on the left. The macro you wish to add to the Quick Access toolbar should be visible in the column on the left.
- Locate the macro you wish to add to the toolbar in the column on the left.
- Highlight the macro and click the "Add" button situated between the 2 columns in the "Quick Access toolbar and keyboard shortcuts" dialogue box. The selected macro will now be visible in the column on the right.
- Click "OK" to exit the dialogue box. The selected macro will now be visible in, and has been assigned to, a button in the Quick Access toolbar.
Method 2 of 2:
Assign a Keyboard Shortcut to a Macro
- Access the "Customize Keyboard Shortcuts" dialogue box.
- Click the "Office" button in the upper-left corner of the application window.
- Click "Word options" located at bottom of the pull-down menu. The Word options dialogue box will open.
- Click the "Customize" button, located in the column on the left, to display the "Customize the Quick Access Toolbar and keyboard shortcuts" dialogue box.
- Click the "Customize Keyboard shortcuts" button located beneath the column on the left. The "Customize Keyboard" dialogue box will open.
- Assign a keyboard shortcut to a preexisting macro previously saved to the macros library.
- Highlight the Macros option in the "Categories" menu, located on the left side of the dialogue box. A list of the macros stored in the macro library will now be visible in the column on the right.
- Highlight the macro you wish to assign a keyboard shortcut to, which should be visible in the column on the right.
- Click inside the "Press new shortcut key" field located on the lower right side of the dialogue box so that the cursor can be seen flashing in the empty field.
- Type a combination consisting of 2 to 3 keys using your computer keyboard. The combination you've selected will be visible in the "Press new shortcut key" field. If the combination you have chosen is already being used, it will appear beneath the "Current keys" box under "Currently assigned to." Delete the key combination located inside the "Press new shortcut key" field if the shortcut is already being used and type a new one.
- Click the "Assign" button, and then click close once you have entered a key combination that is not already in use in order to exit the dialogue box.
- Click OK to close the "Customize the Quick Access Toolbar" and keyboard shortcuts dialogue box. A keyboard shortcut has been assigned to the macro and the macro will run whenever the combination of keys assigned are pressed.
4 ★ | 1 Vote
You should read it
- How to Remove a Macro in Excel
- How to Create a Custom Macro Button in Excel
- How to Create an OpenOffice Macro
- How to turn on / off Macro in Word
- How to disable Macro mode and auto-switch on iPhone camera
- How to troubleshoot macros in Excel not working
- errno.h in C
- The class of macro camera of the Galaxy A51 is what users rarely see
- An unprecedented beautiful snowflake macro camera appeared
- What is a macro in Excel? How to create and run a Macro in Excel
- MS Excel 2003 - Lesson 8: Excel Macro - Automate complex tasks
- Steps to resize PowerPoint images with Macro