Quadra

Connecting Technology and Business.

Run a macro by just clicking on a button

​Add a macro as a button to the Quick Access Toolbar or to a custom group

To add your macro to the Quick Access Toolbar as a button:

 

  1. Click the File tab, and then click Options.
  2. Click Quick Access Toolbar.
  3. Under Choose Commands from, select Macros.
  4. Find and select your macro in the list.
  5. Click Add and then click OK.
  6. To change the name of the macro that's shown on the Quick Access Toolbar, click Modify and type the name you want displayed in the Display name box.
  7. Use the Move Up and Move Down buttons (to the right of the box) to change the position of the buttons on the Quick Access Toolbar.

 

To add a custom group to a tab and then add your macro to that custom group as a button:

 

  1. Click the File tab, and then click Options.
  2. Click Customize Ribbon.
  3. In the pane on the right, select the tab on which you want to create a custom group, such as the Developer tab.
  4. Create a new group by clicking New Group.
  5. Click Rename to change the name of your custom group, and then click OK.
  6. With your new group selected, in the pane on the left, find and select your macro under Choose Commands from.
  7. Click Add to add the macro to your custom group.
  8. To change the text that's shown next to the icon, click Rename and type the text you want displayed in the Display name box.
    As an optional step, choose a new symbol for your button in the Rename dialog box.
  9. Click OK.
Loading