Macro security settings in Excel - Step-by-Step Guide

Introduction

Macro security settings help protect your computer from harmful code in Excel files. They control when and how macros can run, so you can safely use useful automation without risk.

When you receive an Excel file with macros from someone else and want to check if it is safe to run them

When you want to enable macros only for trusted documents to avoid viruses

When you create your own macros and want to test them without security blocks

When your company requires specific macro security levels to protect data

When you want to disable all macros to prevent any automatic code from running

Steps

Step 1: Click

- File tab

The backstage view opens showing file options

Step 2: Click

- Options button at the bottom left

The Excel Options window opens

Step 3: Click

- Trust Center category on the left

Trust Center settings options appear on the right

Step 4: Click

- Trust Center Settings button

The Trust Center window opens with security options

Step 5: Click

- Macro Settings category on the left

Macro security options appear on the right

Step 6: Select

- One of the macro security options

The selected macro security level is applied

💡 Choose 'Disable all macros with notification' to get a prompt before macros run

Step 7: Click

- OK button in Trust Center window

Trust Center window closes and settings are saved

Step 8: Click

- OK button in Excel Options window

Excel Options window closes and you return to Excel

Before vs After

Before

Excel runs all macros automatically without warnings, which can be risky

After

Excel shows a security warning before running macros, letting you decide to enable or disable them

Settings Reference

Disable all macros without notification

📍 Trust Center > Trust Center Settings > Macro Settings

Blocks all macros from running silently without any alerts

Default: Enabled

Disable all macros with notification

📍 Trust Center > Trust Center Settings > Macro Settings

Blocks macros but shows a security warning so you can choose to enable them

Default: Disabled

Disable all macros except digitally signed macros

📍 Trust Center > Trust Center Settings > Macro Settings

Allows only macros signed by trusted publishers to run

Default: Disabled

Enable all macros (not recommended)

📍 Trust Center > Trust Center Settings > Macro Settings

Allows all macros to run without any restrictions or warnings

Default: Disabled

Common Mistakes

Choosing 'Enable all macros' without understanding the risk

This setting allows any macro to run, including harmful ones, which can damage your computer or data

Use 'Disable all macros with notification' to stay safe and only enable macros you trust

Ignoring the security warning and enabling macros from unknown sources

Macros from unknown sources can contain viruses or malicious code

Only enable macros if you trust the file source and understand what the macro does

Summary

Macro security settings control when Excel runs automated code to keep your computer safe

You can choose to disable macros, allow only trusted ones, or enable all with warnings

Always be cautious and enable macros only from sources you trust

Practice

1. What is the main purpose of Macro Security Settings in Excel?

easy

A. To change the font size of cells automatically

B. To sort data alphabetically

C. To create charts from data

D. To control if and how macros run to protect your computer

Solution

1. Step 1: Understand what macros are

   Macros are small programs that automate tasks in Excel.

2. Step 2: Identify the role of security settings

   Macro security settings control whether these programs can run, protecting your computer from unsafe code.

3. Final Answer:

   To control if and how macros run to protect your computer -> Option D

4. Quick Check:

   Macro security controls macro execution [OK]

Hint: Macros can be risky; security settings keep you safe [OK]

Common Mistakes:

• Confusing macro security with formatting options
• Thinking macro security changes data sorting
• Assuming macro security creates charts

2. Which menu path do you follow to change Macro Security Settings in Excel?

easy

A. File > Options > Trust Center > Trust Center Settings > Macro Settings

B. Home > Clipboard > Paste Special

C. Insert > Table > Macro Settings

D. View > Zoom > Macro Security

Solution

1. Step 1: Locate Excel Options

   Click File, then Options to open Excel settings.

2. Step 2: Find Trust Center and Macro Settings

   Inside Options, select Trust Center, then Trust Center Settings, and finally Macro Settings.

3. Final Answer:

   File > Options > Trust Center > Trust Center Settings > Macro Settings -> Option A

4. Quick Check:

   Macro settings are under Trust Center [OK]

Hint: Macro settings live in Trust Center under Options [OK]

Common Mistakes:

• Looking for macro settings under Insert or View menus
• Confusing macro settings with clipboard or zoom options
• Skipping Trust Center step

3. If Macro Security is set to 'Disable all macros with notification', what happens when you open a workbook with macros?

medium

A. Macros are disabled but you get a security warning to enable them

B. Macros are disabled and no notification appears

C. Macros run automatically without warning

D. Excel crashes immediately

Solution

1. Step 1: Understand the setting meaning

   'Disable all macros with notification' means macros do not run automatically but you get a warning.

2. Step 2: Identify user action

   You can choose to enable macros after seeing the notification.

3. Final Answer:

   Macros are disabled but you get a security warning to enable them -> Option A

4. Quick Check:

   Disable with notification means warning shown [OK]

Hint: Disable with notification means macros off until you approve [OK]

Common Mistakes:

• Thinking macros run automatically
• Assuming no notification appears
• Believing Excel crashes on macro security

4. You set Macro Security to 'Enable all macros' but macros still do not run. What is a likely cause?

medium

A. You need to restart Excel twice

B. The workbook is opened from an untrusted location and Trust Center blocks macros

C. Excel does not support macros

D. You forgot to save the workbook

Solution

1. Step 1: Check macro security setting

   Setting 'Enable all macros' allows macros to run without prompts.

2. Step 2: Consider Trust Center trusted locations

   If the file is from an untrusted location, Trust Center may block macros despite settings.

3. Final Answer:

   The workbook is opened from an untrusted location and Trust Center blocks macros -> Option B

4. Quick Check:

   Untrusted location blocks macros even if enabled [OK]

Hint: Check if file location is trusted when macros don't run [OK]

Common Mistakes:

• Assuming Excel does not support macros
• Thinking saving or restarting fixes macro blocking
• Ignoring Trust Center trusted locations

5. You want to allow macros only from trusted publishers but block all others. Which Macro Security setting should you choose?

hard

A. Disable all macros without notification

B. Disable all macros with notification

C. Disable all macros except digitally signed macros

D. Enable all macros

Solution

1. Step 1: Understand the requirement

   You want to allow macros only if they come from trusted, digitally signed publishers.

2. Step 2: Match setting to requirement

   'Disable all macros except digitally signed macros' allows only signed macros to run, blocking others.

3. Final Answer:

   Disable all macros except digitally signed macros -> Option C

4. Quick Check:

   Signed macros allowed only = Disable all macros except digitally signed macros [OK]

Hint: Choose signed macros only to trust known publishers [OK]

Common Mistakes:

• Choosing 'Enable all macros' which allows all macros
• Picking 'Disable all macros with notification' which warns but blocks all
• Confusing signed macros with notifications