Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons

Return to the table and continue to step 12.

Point to each of the macro buttons in the Quick Access Toolbar . Notice that the name of each macro appears in a ScreenTip .

Select cell A1 in the worksheet, if necessary, then click the Company macro button on the Quick Access Toolbar . Notice that the macro inserts the company name into the selected cell.

C HANGING A QAT M ACRO B UTTON I MAGE  D ISCUSSION

When a macro is added to the Quick Access Toolbar , the same button image is displayed for each macro. You can easily change the button image; Excel provides numerous images from which you can choose.

When you hover the mouse pointer over a macro button, a ScreenTip displays the name of the macro. You can change the text that appears in the ScreenTip , if desired, to describe what the macro does.

Changing a button image

NOTE You can also open the Customize page in the Excel Options dialog box by right-clicking on a button in the Quick Access Toolbar and selecting Customize Quick Access Toolbar .

OFFICEPRO, Inc.

Page 73