Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016

U SING A M ACRO B UTTON  D ISCUSSION

You can create a button in your worksheet that will run an associated macro. Macro buttons make it easier to run your macros and can help even an inexperienced user perform complex worksheet tasks.

You can draw a macro button anywhere on the worksheet, as well as create as many macro buttons as needed to perform different worksheet tasks.

Like other graphic objects, macro buttons are not stored in cells; they lie over the worksheet.



P ROCEDURES

1. Open a workbook containing a macro button and enable the macros. 2. Click the desired macro button.



S TEP - BY -S TEP From the Student Data directory, open CITY60.XLSM . Use a macro button.

If necessary, enable the macros.

The macro used in the following steps opens the ATLANTA.XLSX workbook but does not contain a file path. As a result, it will look in the current folder for the file. If you opened the CITY60.XLSM file by selecting it from the recently used files list, the current folder may not be the folder that contains the ATLANTA.XLSX file. Make sure that your current folder is set for the path containing the student data files by using the Open command in the Office menu to open the CITY60.XLSM file.

Steps

Practice Data

1. Click the desired macro button. The associated macro runs .

Click

Close ATLANTA.XLSX.

Page 60

OFFICEPRO, Inc.