Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016

If necessary, enable the macros, show the Developer tab in the Ribbon and make sure that your current folder is set for the path containing the student data files.

Steps

Practice Data

1. Hold [Ctrl] and drag the macro

Hold [Ctrl] and drag the Open Chicago button into cell H6

button you want to copy to where you want the copy to appear. The mouse pointer changes into an arrow with a plus sign and an outline appears as you drag.

2. Release the mouse button. A copy of the macro button appears on the worksheet.

Release the mouse button

3. Release the [Ctrl] key.

Release the [Ctrl] key

The mouse pointer returns to its normal shape.

4. Select any cell in the worksheet to deselect the macro button copy. The macro button copy is deselected. 5. Right-click the macro button copy. A shortcut menu opens. 6. Select Assign Macro from the shortcut menu. The Assign Macro dialog box opens. 7. Select the desired macro from the list in the Assign Macro dialog box. The macro name appears in the Macro name box.

Click anywhere in the worksheet

Right-click the Open Chicago copy

Click Assign Macro

Click NewYork

8. Select OK .

Click

The Assign Macro dialog box closes.

9. Select the text you want to edit on the macro button copy. The text is selected.

Double-click Chicago on the Open Chicago copy

Page 64

OFFICEPRO, Inc.