Читать книгу Excel 2019 Power Programming with VBA - Michael Alexander, Dick Kusleika - Страница 84

You can also assign a macro to a button in Excel's Quick Access toolbar. The Quick Access toolbar sits either above or below the Ribbon. You can add a custom button that will run your macro by following these steps:

1 Right-click your Quick Access toolbar and select Customize Quick Access Toolbar. This will open the dialog box illustrated in Figure 2.9.FIGURE 2.9 Adding a macro to the Quick Access toolbar

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

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

4 Click the Modify button to choose an icon for your macro and provide a friendly display name.

5 Click the OK button.