How to Fix Excel Macro Warnings and Automatic VBA Blocking
Question details
The user needs a way to stop new backup warnings for VBA projects and prevent Microsoft 365 from automatically disabling macros in important business workbooks.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- not provided
- Scenario
- Opening and attempting to run VBA scripts in an essential business workbook.
- Observed behavior
- Excel displays unfamiliar warnings prompting the user to back up their VBA project, and subsequently blocks or disables the macros automatically, disrupting workflow.
Before altering any security settings, verify that you have a secure backup of your business workbook and its VBA project, and write down the exact warning message for accurate troubleshooting.
Unblock the Specific Excel File via Windows Properties
This is the safest and most recommended method to allow macros to run on an individual file downloaded from the internet or received via email without lowering your system's overall security.
Microsoft 365 now automatically blocks macros in files that carry the 'Mark of the Web' (MotW). This means files originating from outside your local computer are restricted by default. Unblocking the specific file removes this restriction.
Ensure that the Excel workbook with the blocked macros is completely closed so Windows can modify its properties.
Open Windows File Explorer and navigate to the folder where your business workbook is saved.
Right-click the Excel file and select 'Properties' from the context menu.
At the bottom of the 'General' tab, locate the Security section. Check the box labeled 'Unblock' next to the warning, then click 'Apply' and 'OK'.
Set Up a Trusted Location in Excel Trust Center
If you frequently work with multiple business workbooks in a specific folder, adding that folder as a Trusted Location prevents Excel from blocking any macros within those files.
Tired of Microsoft 365 Subscription Hassles? Try WPS Office
If aggressive macro security updates and mandatory Microsoft 365 subscription changes are disrupting your business workflow, WPS Office offers a highly compatible, user-friendly, and cost-effective alternative without the forced interruptions.
- 1. Download the Suite: Visit the official website to download and install the free WPS Office application.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets, click on Menu, and select Open to seamlessly load your existing Excel workbooks.
- 3. Resume Your Work: View, edit, and analyze your business data in a familiar environment tailored for productivity.
Frequently Asked Questions
Why is Microsoft 365 suddenly blocking my Excel macros?
Microsoft recently updated its default security policy to automatically block VBA macros in files originating from the internet or email attachments. This 'Mark of the Web' (MotW) protection is designed to prevent malware and ransomware attacks.
Will reverting to Office 2019 or Office 2021 permanently stop these macro warnings?
Not necessarily. Microsoft deploys security updates across all supported versions of Office, including perpetual licenses like Office 2019 and 2021. The automatic macro blocking feature is a system-wide security enhancement that applies to these versions as well.
Can I completely disable macro security to stop the warnings?
While it is technically possible to enable all macros via the Trust Center, it is highly discouraged. Doing so leaves your system entirely unprotected against malicious scripts. It is much safer to unblock individual files or use designated Trusted Locations.
How do I safely back up my VBA project in Excel?
To back up your VBA code, press Alt + F11 to open the Visual Basic Editor. Right-click on your modules or user forms in the Project Explorer on the left, select 'Export File', and save them to a secure location on your hard drive.
