Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 27

You can also assign a macro to a button on the Quick Access Toolbar. The Quick Access Toolbar sits either above or below the Ribbon. You can add a custom button that runs your macro by following these steps:

1 Right-click your Quick Access Toolbar and select Customize Quick Access Toolbar.This opens the dialog box shown in Figure 1-9.

2 Select Macros from the Choose Commands From drop-down list on the left.

3 Select the macro you want to add and click the Add button.

4 (Optional) Click the Modify button to change the icon or display name, and then click OK to close the Modify Button dialog box.

5 Click OK to close the Excel Options dialog box.

FIGURE 1-9: Adding a macro to the Quick Access Toolbar.