Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

O PENING A W ORKBOOK C ONTAINING M ACROS  D ISCUSSION

The default macro security setting in Excel checks every workbook you open that is not stored in a Trusted Location to see if it contains macros. If it finds any macros, it disables them before opening the workbook and a Message Bar appears above the workbook containing a Security Warning notifying you with a link that Macros have been disabled together with an Enable Content button.

Clicking the Enable Content button opens the workbook and enables the macros in it. Clicking the Macros have been disabled link opens the File tab at the Info page displaying the Security Warning and options.

Security warning

NOTE The Learn more about Active Content link in the Security area opens Excel Help and displays a page which describes the security options in detail.

Page 14

OFFICEPRO, Inc.