Is VBA Supported in Excel Co-Authoring? Limitations & Workarounds
Question details
The user needs to know if VBA macros can be used while multiple users are simultaneously co-authoring an Excel workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to run VBA macros while working collaboratively on a shared Excel workbook.
- Observed behavior
- VBA macros stop working or do not execute reliably when the workbook is actively being co-authored by multiple users, even within the desktop application.
Verify whether your macros are failing due to simultaneous co-authoring or simply because Windows has blocked macros in a file downloaded from the internet, as these are two separate security behaviors.
Migrate to Office Scripts or Power Automate
Since VBA is not fully supported for simultaneous co-authoring, migrating to cloud-native automation tools is the most reliable solution for collaborative workflows.
VBA was designed for single-user desktop environments. When multiple users edit a file concurrently, VBA execution is often restricted to prevent data corruption and sync conflicts. Microsoft recommends using Office Scripts for web-based and co-authored workbooks.
Log into your Microsoft 365 account and open your shared workbook in Excel for the Web, as Office Scripts are primarily managed here.
Click on the 'Automate' tab on the ribbon. If you do not see it, ensure your organization has enabled Office Scripts.
Click 'New Script' or use the 'Record Actions' feature to replicate the behavior of your legacy VBA macro in TypeScript, which is fully supported during co-authoring.
Use Personal Macro Workbooks
Store macros locally on individual computers so the shared collaborative file remains macro-free (.xlsx).
Unblock Downloaded Excel Files
Fix macro blocking issues caused by Windows security settings on files downloaded from the internet or email.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by Excel's complex macro limitations and expensive subscriptions, consider switching to WPS Office. It offers a robust desktop experience with excellent VBA macro support, high compatibility with Office formats, and a user-friendly interface.
- 1. Download and Install: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsm files directly; no format conversion is necessary.
- 3. Enable Macros: Follow the on-screen prompts to enable macros safely and enjoy seamless VBA execution in your local environment.
Frequently Asked Questions
Why do macros stop working when I share an Excel workbook?
Standard VBA macros are not designed for simultaneous co-authoring. When multiple users edit a file concurrently, Excel often restricts VBA execution to prevent data corruption, synchronization conflicts, and structural damage to the workbook.
Does unblocking a downloaded Excel file fix co-authoring macro issues?
No. Unblocking a downloaded file resolves Windows security restrictions (known as Mark of the Web), which prevents macros from running entirely. However, it does not bypass the inherent functional limitations of running VBA during an active co-authoring session.
Can I use the legacy 'Share Workbook' feature to run macros collaboratively?
The legacy 'Share Workbook' feature has severe limitations, lacks real-time co-authoring capabilities, and often causes VBA macros to fail even within the desktop application. It is generally deprecated and not recommended for modern collaborative workflows.
What is the best alternative to VBA for collaborative Excel files?
Microsoft recommends using Office Scripts and Power Automate for collaborative workbooks. Unlike VBA, Office Scripts are built with TypeScript, run in the cloud, and are specifically designed to function reliably during active co-authoring sessions.
