Excel 2016 Macros

Excel 2016

Lesson 4 – Creating Macro Buttons

E XERCISE

C REATING M ACRO B UTTONS



T ASK Create and work with macro buttons on a worksheet.

1. Open EXER85.XLSM and enable the macros. 2. Display the Developer tab.

3. Draw a macro button in the range M7:M8. Assign the Eastern macro to the macro button and change the button text to Eastern Sales . Then, italicize the button text. 4. Deselect the Eastern Sales button and click it to test it. 5. Drag to create a copy of the Eastern Sales button. Position its top, left corner at the top, left corner of cell M3. Assign the ClearOutput macro to the macro button and rename it Clear Report . 6. Deselect the Clear Report button and then click it to test it. 7. Move the Clear Report button below the Eastern Sales button, aligning it to the top, left corner of cell M10. 8. Widen the Clear Report button to extend across both columns M and N. 9. Delete both macro buttons. 10. Hide the Developer tab. 11. Customize the Quick Access Toolbar For EXER85.XLSM and add the Eastern , Southern , and Western macros. 12. Modify the Western macro button and assign the left-pointing arrow symbol (row 2, last column) to the button. Change the Display name to Western Sales . 13. Modify the Eastern and Southern macros in a similar way, assigning appropriate arrow symbols to the buttons and changing the Display name to add the word Sales . 14. Remove all three macro buttons from the Quick Access Toolbar . 15. Close the workbook without saving it.

OFFICEPRO, Inc.

Page 77