0
0
Excelspreadsheet~5 mins

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

Choose your learning style9 modes available
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