Macro security settings in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of Macro Security Settings in Excel?

Macro Security Settings control whether macros can run in Excel files to protect your computer from harmful code.

beginner

Name the four main Macro Security levels in Excel.

The four main levels are: Disable all macros without notification, Disable all macros with notification, Disable all macros except digitally signed macros, and Enable all macros (not recommended).

beginner

What happens if you set Macro Security to 'Disable all macros with notification'?

Excel will block macros from running but will show a warning so you can choose to enable them if you trust the file.

beginner

Why is 'Enable all macros' not recommended?

Because it allows all macros to run without any warning, which can let harmful or malicious code run on your computer.

beginner

How can you access Macro Security Settings in Excel?

Go to the File tab > Options > Trust Center > Trust Center Settings > Macro Settings.

Which Macro Security setting shows a warning before running macros?

A Disable all macros without notification

B Disable all macros with notification

C Enable all macros

D Disable all macros except digitally signed macros

The 'Disable all macros with notification' setting blocks macros but shows a warning so you can choose to enable them.

Where do you find Macro Security Settings in Excel?

A File tab > Options > Trust Center > Trust Center Settings

B Insert tab > Add-ins

C View tab > Macros

D Home tab > Clipboard

Macro Security Settings are under File > Options > Trust Center > Trust Center Settings.

What is the safest Macro Security setting to prevent all macros from running?

A Enable all macros

B Disable all macros except digitally signed macros

C Disable all macros with notification

D Disable all macros without notification

'Disable all macros without notification' blocks all macros and does not show any warnings.

Why should you be careful when enabling macros?

A Macros use a lot of memory

B Macros can slow down Excel

C Macros can contain harmful code that damages your computer

D Macros change your Excel theme

Macros can contain harmful or malicious code, so enabling them without caution can be risky.

What does 'Disable all macros except digitally signed macros' do?

A Allows only macros with a trusted digital signature to run

B Blocks all macros without warning

C Allows all macros to run

D Disables macros only in new files

This setting allows only macros that have a trusted digital signature to run, blocking others.

Explain the different Macro Security levels in Excel and when you might use each.

Think about safety versus convenience.

Describe how to change Macro Security Settings in Excel step-by-step.

Follow the menu path carefully.