Excel 2019 Bible

Chapter 42: Introducing Visual Basic for Applications

42

1. Right-click any Ribbon control, and select Customize the Ribbon from the
   shortcut menu. The Customize Ribbon tab of the Excel Options dialog box appears.


2. In the list box on the right, place a check mark next to Developer.


3. Click OK to return to Excel.

Learning about Macro Security

Macros have the potential to cause serious damage to your computer, such as erasing files

or installing malware. Consequently, Microsoft has added macro-security features to help

prevent macro-related problems.

Figure 42.2 shows the Macro Settings section of the Trust Center dialog box. To display this

dialog box, choose Developer ➪ Code ➪ Macro Security.

FIGURE 42.2

The Macro Settings section of the Trust Center dialog box

By default, Excel uses the Disable All Macros with Notification option. With this setting in

effect, if you open a workbook that contains macros (and the file is not already trusted),

the macros will be disabled, and Excel will display a security warning above the Formula

bar (see Figure 42.3). If you’re certain that the workbook comes from a trusted source, click

the Enable Content button in the security warning area, and the macros will be enabled.