Microsoft Office Tutorials and References
In Depth Information
Assigning VBA Macros to Quick Access Toolbar Buttons
dialog starts with just 53 popular commands in the left list box, use
the left drop-down to choose All Command or Commands Not in the Rib-
bon. When you find a command in the left list box, select the command
and then click Add>> in the center of the dialog to add that command to
the QAT.
You can reset the QAT to its original default state using the Reset
button in the lower right.
You can export your custom QAT icons from your computer and im-
port on another computer.
You can move the QAT to appear above or below the ribbon using the
check box in the lower right.
Assigning VBA Macros to Quick Access Toolbar Buttons
Assigning VBA Macros to Quick Access Toolbar Buttons
Typically, a VBA macro is assigned to a shortcut key. In legacy versions of
Excel, it was easy to customize the menu system to add commands to invoke
macros. Excel 2013 offers a weak interface for adding custom macros to the
QAT. In the Excel Options dialog is a drop-down called Macros. If you select
this group, you see all public macros in all open workbooks. You can select
a macro and click Add to add that macro to the QAT.
Initially, every macro added to the Quick Access Toolbar gets an identical
flowchart icon. However, you can select an icon in the Customize Quick Ac-
cess Toolbar list box and click the Modify button. The Modify Button dia-
log that appears enables you to choose from 55 available icons for a macro
as shown in Figure 3.24 . Most of these buttons are similar to icons that are
already popular. For example, the Print icon is fairly well known and has a
meaning. In addition to choosing from the 55 icons, you can type any text for a
display name. The display name does not appear next to the button. However,
if you hover your mouse over the icon on the QAT, you can see the display
name in a tooltip.
Search JabSto ::




Custom Search