HomeApplicationOffice informationHow to Add a Button to a Macro

How to Add a Button to a Macro

Method 1 of 2:

Add a Macro to a Toolbar in Microsoft Office

  1. How to Add a Button to a Macro Picture 1
    Assign a preexisting macro, saved to the macro library, to a button in the Quick Access toolbar.
    1. Open a new document and click the "Office" button in the upper-left corner of the application window.
    2. Click "Word options" located at the bottom of the pull-down menu. The Word options dialogue box will open.
    3. Click the "Customize" button, located in the column on the left, to display the "Customize the Quick Access Toolbar and keyboard shortcuts" dialogue box.
    4. 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.
    5. Locate the macro you wish to add to the toolbar in the column on the left.
    6. 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.
    7. 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

  1. How to Add a Button to a Macro Picture 2
    Access the "Customize Keyboard Shortcuts" dialogue box.
    1. Click the "Office" button in the upper-left corner of the application window.
    2. Click "Word options" located at bottom of the pull-down menu. The Word options dialogue box will open.
    3. Click the "Customize" button, located in the column on the left, to display the "Customize the Quick Access Toolbar and keyboard shortcuts" dialogue box.
    4. Click the "Customize Keyboard shortcuts" button located beneath the column on the left. The "Customize Keyboard" dialogue box will open.
  2. How to Add a Button to a Macro Picture 3
    Assign a keyboard shortcut to a preexisting macro previously saved to the macros library.
    1. 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.
    2. Highlight the macro you wish to assign a keyboard shortcut to, which should be visible in the column on the right.
    3. 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.
    4. 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.
    5. 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.
    6. 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
macroboxclick

You should read it

May be interested

  • How to Print in Office 2007Photo of How to Print in Office 2007
    office 2007 contains a full suite of printing tools that allow you to print your documents and spreadsheets exactly how you want. printing a document is fairly straightforward, but there are a lot of tweaks you can make to get a more...
  • How to Change the Tab Colors in OneNote 2013Photo of How to Change the Tab Colors in OneNote 2013
    coming over from an older version of onenote and heard how you can now change the notebook and notebook tab/folder colors? this wikihow will teach you how its done. open the onenote notebook switcher and hover over the name of the notebook...
  • How to Use Office 2003 Menus and Toolbars in Microsoft Office 2007 and 2010Photo of How to Use Office 2003 Menus and Toolbars in Microsoft Office 2007 and 2010
    both microsoft office 2007 and 2010 has embedded a new interface ribbon, a panel that deploys and organizes all the commands as a set of tabs. in microsoft office 2007, the ribbon is present in word 2007, excel 2007, powerpoint 2007,...
  • How to Personalize Microsoft OfficePhoto of How to Personalize Microsoft Office
    we all have microsoft office installed on our computers. very few of us change our office settings to make it ours. you can sign into your microsoft account so that all your documents and settings are synchronized across all your products...
  • How to Open Multiple Documents in Microsoft Office ApplicationsPhoto of How to Open Multiple Documents in Microsoft Office Applications
    can you open multiple documents in your microsoft office applications (word, excel, powerpoint…) within a single window? this article is going to tell you how to use a tabbed document interface in your microsoft office applications to i...
  • How to Enable AutoRecover in Microsoft Office 2010Photo of How to Enable AutoRecover in Microsoft Office 2010
    does this sound familiar? you are working in excel, word or access in microsoft office 2010, and your device suddenly crashes, in the middle of a session. you have not saved your document yet, losing all of your hard work and progress....

Office information