Excel 2016 Macros

Excel 2016

Lesson 1 - Using Macros

Steps

Practice Data

10.

Open the folder you want to add

Double-click to open the student data folder

to the Trusted Locations list. The folder opens.

11.

Select the left-hand part of the OK

Click

button. The Browse dialog box closes and the selected drive and folder appear in the Path box in the Microsoft Office Trusted Location dialog box. Select the Subfolders of this location are also trusted option, if required. The option is selected. Select the Description box. The insertion point appears in the Description box. its contents. The text appears in the Description box. Select OK . The Microsoft Office Trusted Location dialog box closes and the folder name appears in the User Locations section of the Trusted Locations list. If the folder you added resides on a network drive, select the Allow Trusted Locations on my network not recommended) option. The option is selected, if necessary. Select OK . The Trust Center dialog box closes. Select OK . The Excel Options dialog box closes. Type a description of the folder or

12.

Click Subfolders of this location are also trusted to select it

13.

Click in the Description box

14.

Type My macros

15.

Click

16.

Click Allow Trusted Locations on my network (not recommended) to select it, if necessary

17.

Click

18.

Click

Practice the Concept: Open the Trust Center and display the Trusted Locations page. Select the student data folder in the list and click the Remove button.

OFFICEPRO, Inc.

Page 13