Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

NOTE The Trust Center Settings link in the Security area opens the Trust Center , where you can view the list of Trusted Publishers, Documents, or other items and remove publishers from the list, if required. You can also view and edit the list of Trusted Locations , change security settings for macros and control whether the Message Bar is displayed when content is blocked. For this topic to work properly, macro security must be set to the default setting. To check and, if necessary, set the correct option, select the File tab , the Excel Options button, the Trust Center page, and the Trust Center Settings button. Then, select the Disable all macros with notification option and OK twice.



P ROCEDURES

1. Select the File tab . 2. Select Open from the list on the left side of the screen. 3. Click Browse 4. From the left side of the screen, select the drive in which the workbook you want to open is located. 5. Open the folder in which the workbook you want to open is located. 6. Select the file name of the workbook you want to open.

7. Select the left-hand part of the Open button

.

8. Select the

.



S TEP - BY -S TEP Open a workbook containing macros.

Steps

Practice Data

1. Select the File tab . The Backstage view opens. 2. Select Open from the File menu. The Open screen appears. 3.Click Browse. A list of available drives and common folders appears.

Click

Click Open

Click

OFFICEPRO, Inc.

Page 15