Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

The Macros button opens the Macro dialog box so that you can run a macro. The Record Macro button allows you to record a macro. The Visual Basic button opens the Visual Basic Editor window, in which you can edit an existing macro or write new macros.

The Macro Security button opens the Trust Center on the Macro Settings page so that you can set the security level you want to use when opening workbooks containing macros.

Other buttons are used for automating forms and working with HTML tags and scripts for workbooks saved as web pages.

The Developer tab



P ROCEDURES

1. Select the File tab

.

2. Select Options . 3. Click Customize Ribbon . 4. Select the Developer check box. 5. Select . 6. Select the Developer tab.



S TEP - BY -S TEP

Display the Developer tab.

Steps

Practice Data

1. Select the File tab . The Office menu opens.

Click

2. Select Options . The Excel Options page opens with the General page displayed in the right-hand pane. 3. Click Customize Ribbon. 4. The Customize Ribbon page opens.

Click Options

Click Customize Ribbon .

Page 20

OFFICEPRO, Inc.