For most people using Excel for Microsoft 365 on Windows, the best choice is Disable VBA macros with notification. It keeps macros off unless you deliberately allow them, while still letting you run a macro in a workbook you trust; keep the separate setting that blocks macros in files from the internet turned on as well.
What to Look For
Excel macro settings are a security choice, not a way to make a particular workbook’s macros work better. VBA macros can automate repetitive work, but they can also change or delete data, access files, or perform other actions you did not intend. Choose a setting by weighing how often you need macros against how much control you need over which files can run them.
- Whether macros run automatically: The key difference between settings is whether VBA is disabled, disabled with a warning, limited to signed code, or allowed without a warning. A warning gives you a chance to decide for each workbook, but it does not prove that a file is safe.
- Where the workbook came from: A macro-enabled workbook from a known colleague or your organization is different from an unexpected attachment or download. Be cautious even if a file looks familiar: attackers can impersonate senders or use convincing filenames.
- How the code is approved: A digital signature can identify a publisher and show whether signed code has changed. It is useful only when you trust the publisher and your organization has a way to issue and manage signatures.
- Whether you need VBA at all: Ordinary workbooks do not need macros to open or calculate. Files with VBA commonly use extensions such as .xlsm, .xlsb, or .xlam. If you do not use VBA, there is little reason to allow it.
- Organization rules and file location: A company administrator may enforce macro settings or block internet-originated files. A trusted location can make controlled work easier, but files placed there may receive fewer security checks, so it must be tightly managed.
On Windows, review the controls in File > Options > Trust Center > Trust Center Settings > Macro Settings. The names of individual choices can vary slightly with Office updates or organizational policy. Keep Block macros from running in Office files from the Internet enabled if the checkbox is available. This is a separate safeguard from the main VBA macro choice, and it may prevent downloaded files from offering the usual option to enable content.
1. Disable VBA Macros with Notification: Best Default
This is the strongest everyday balance for people who sometimes need a macro but do not want every macro-enabled file to run automatically. Excel disables VBA by default and displays a security warning when a workbook contains macros and can be enabled. You decide whether to allow the code for that file rather than lowering protection for all workbooks.
Strengths: It helps prevent unwanted macros from running just because you opened a file. It also keeps a practical route for occasional, legitimate automation, such as a reporting workbook supplied by your organization. You can leave a non-macro workbook alone and make a decision only when Excel identifies VBA content.
Trade-offs: The warning is a prompt, not a safety check. Clicking Enable Content can allow harmful code to run, so do not treat the button as routine. Files marked as coming from the internet may be blocked outright by Office, without the normal enable option; that behavior is intentional. Do not bypass it simply because a workbook is inconvenient to open.
Best for: Home users, students, and most office workers who use macros occasionally or receive workbooks from a small number of known sources. For many people, this is the right “set it and leave it” choice.
2. Disable VBA Macros without Notification: Best for Users Who Never Need VBA
This option turns off VBA macros without showing the usual warning. It suits a computer where macros are not part of the work and where a prompt would only cause confusion or invite someone to enable code without a real reason. The exact wording in Trust Center is Disable VBA macros without notification.
Strengths: It removes the routine decision to enable a macro and reduces the chance that someone will approve code just to clear a banner. If your workbooks are all ordinary .xlsx files and your processes do not depend on VBA, this is a simple restrictive setting.
Trade-offs: A workbook that relies on macros may open with features missing or buttons that do nothing, and Excel may not explain why in the same obvious way as the notification setting. You will need to change the setting, use a properly approved alternative, or ask your IT administrator if a legitimate task stops working. This setting does not prevent every possible risk from other Office features or file types.
Best for: People who do not run VBA, shared or public computers, and tightly controlled environments where users should not make per-file decisions. If you are not sure whether a recurring work process uses a macro, check before selecting it.
3. Disable VBA Macros Except Digitally Signed Macros: Best for Managed Teams
This setting allows signed macros while disabling unsigned ones. A digital signature can help you confirm who published the code and whether it has changed since it was signed. In a well-managed workplace, an IT team or trusted developer can sign approved macros and distribute the signing certificate appropriately.
Strengths: It gives users less opportunity to run arbitrary unsigned VBA while preserving a defined route for approved automation. It can be a good fit for teams that rely on shared templates, add-ins, or recurring reports and have a reliable process for validating publishers.
Trade-offs: A signature is not a guarantee that code is harmless. You should trust the publisher, and a valid signature only helps if the certificate is trusted and the signed code has not been changed. A small edit to a workbook or its VBA can invalidate a signature, so a developer may need to sign the updated version again. This option can create support problems if certificates expire or users do not have the required trust configuration.
Best for: Organizations with an IT administrator, controlled macro distribution, and a clear policy for signing and renewing code. It is usually not the simplest choice for a household or a solo user who receives macros from many unrelated sources.
4. Enable VBA Macros: Only for a Controlled, Isolated Need
Enable VBA macros permits VBA code to run without the usual macro warning. Microsoft labels this option as not recommended because potentially dangerous code can run. Although it may seem convenient when you use a trusted macro workbook every day, it also removes an important pause before other VBA files run.
Strengths: It can avoid repeated prompts in a dedicated, controlled workflow that depends on macros, particularly when managed through an organization’s policy and other security controls. It may also be useful for a short-lived troubleshooting task in a controlled environment, if your administrator approves.
Trade-offs: A malicious macro in another workbook can run without the user making the usual per-file decision. A familiar sender name, a plausible invoice, or a file that was safe last month is not enough to establish that its contents are safe today. Switching this setting on for convenience and forgetting to restore it leaves all workbooks in a less protected state.
Best for: Rare, specifically approved situations where there is a separate security plan. It is not a sensible general setting for a personal or everyday work computer. Prefer a signed-macro policy, a trusted location with access controls, or per-workbook approval when those options fit the workflow.
5. Use a Trusted Location for a Controlled Folder
A trusted location is a folder Excel treats as a trusted source for Office files. It is not one of the four main VBA radio-button choices, but it can be a useful way to handle a specific, controlled set of automation files without enabling macros globally. On Windows, manage locations under File > Options > Trust Center > Trust Center Settings > Trusted Locations.
Strengths: A designated folder can make an approved, recurring macro workflow smoother. For example, a team may store reviewed templates in a restricted network folder and grant edit access only to people responsible for maintaining them. This concentrates trust in a location rather than applying it to every workbook the user encounters.
Trade-offs: Excel may trust files in that folder, so putting an unreviewed download there can defeat the purpose. Do not designate broad folders such as Downloads, an entire shared drive, or a folder where many people can add files without review. Trusted locations can also be managed or disabled by an administrator, and policy settings may differ from a user’s own selections.
Best for: A known, maintained collection of approved workbooks in a folder with limited write access. If you cannot control who can add or replace files, a trusted location is not a good shortcut.
How to Choose
Start with how often you use VBA. If you never need macros, choose Disable VBA macros without notification for a quieter, restrictive setup. If you use them occasionally, choose Disable VBA macros with notification. It makes the decision visible when needed without allowing every macro-enabled workbook to run automatically.
Match the setting to your workflow. If a work process uses a handful of approved macros every week, ask whether your organization can sign the code or keep the files in a controlled trusted location. Those approaches can reduce repeated decisions, but they rely on real maintenance: someone must review code, manage access, and handle updates. If the file is from an unfamiliar source, do not enable its macros merely to see what is inside.
Consider the cost of a mistake versus a prompt. A prompt can slow down a legitimate task; allowing all macros can turn one unsafe file into a much larger problem. For most individuals, pausing to verify a known workbook is a reasonable trade-off. When a workbook’s sender, purpose, or origin is unclear, contact the supposed sender through a separate, trusted channel rather than replying to a suspicious message.
Keep internet blocking enabled. Newer Office protections may block macros in files identified as downloaded from the internet, even when your main setting normally shows a notification. Do not assume that a lack of an enable button means Excel is broken. Confirm the file’s source and ask your IT team for the approved process. Avoid removing a file’s internet mark or moving it into a trusted folder just to get around a warning.
Use the right Excel version. Excel for the web can open a macro-enabled workbook, but it cannot run, create, or edit VBA macros. Open it in the desktop Excel app if an approved VBA task requires execution. On Mac, check the current Excel preferences for macro security; the menu and available choices can differ from Windows. In Microsoft 365 for Mac, look under Excel > Preferences > Security or the corresponding macro-security control in your installed version. Organization policies may restrict the options on either platform.
Finally, check with your administrator on a managed computer. Some settings are controlled by organizational policy and may be unavailable or reset. Do not try to override company controls. Tell IT which workbook or process needs VBA, where the file came from, and what task is blocked; they can confirm an approved route.
Frequently Asked Questions
Should I enable macros for a workbook from someone I know?
Only if you expected the workbook, trust the sender and its purpose, and have verified that the file is the one you need. Sender names can be spoofed and accounts can be compromised. If the request is unexpected, confirm it separately before enabling anything.
Does a digital signature mean a macro is safe?
No. A signature can help identify a publisher and show whether signed code has changed, but it does not certify that the code is harmless. Enable signed macros only when you trust the publisher and your organization has a process for approving that publisher.
Why is Excel blocking a downloaded macro file without an Enable Content button?
Office can block VBA macros in files marked as coming from the internet. This is an additional protection, not necessarily a fault. Verify the file and follow your organization’s approved procedure; do not bypass the block just to make the workbook run.
Can I use VBA macros in Excel for the web?
No. Excel for the web can open a macro-enabled workbook, but VBA does not run there and you cannot create or edit VBA macros in the browser. Use desktop Excel for approved VBA work.
Will changing the macro setting affect every workbook?
The main Trust Center setting applies to Excel’s macro handling generally, not just one workbook. That is why notification-based disabling is a practical default for occasional use. Trusted locations and signed-macro policies can provide more targeted workflows, but need careful management.
Bottom Line
For most Excel users, choose Disable VBA macros with notification, leave internet-originated macro blocking enabled, and allow code only when you have verified the workbook and its source. Choose “without notification” if you never use VBA; reserve signed macros and trusted locations for controlled workflows. Avoid enabling all macros as a permanent convenience setting, and follow your administrator’s policy on a managed device.
Related
- The Z Table in Statistics: How to Read and Use It
- How to Group Rows in JMP
- How to Subtotal Data in Excel and Summarize Groups
Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.
More in VBA & macros
- VBA Split: How to Turn Text into an Array in ExcelYes. In Excel VBA, use the Split function to divide a string at a delimiter and return the…
- VBA Scripting.Dictionary: How It Works and How to Use ItA VBA Scripting.Dictionary stores data as unique keys paired with values, so code can look up an item…
- Excel VBA Open File Dialog: A Practical GuideTo show an Open dialog in Excel VBA, use Application.FileDialog(msoFileDialogFilePicker), set its title and filters, and call .Show.…
- Excel VBA: Display a Variable Value in a MsgBoxIn Excel VBA, display a variable in a message box by passing it to MsgBox, for example MsgBox…
- VBA Access: Import CSV Files ReliablyTo import a CSV file into Microsoft Access with VBA, call DoCmd.TransferText using the acImportDelim transfer type, the…
- Excel VBA Hyperlink to Worksheet: A Practical GuideTo make a cell link to another worksheet with VBA, use Hyperlinks.Add and set Address to an empty…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.