VBA & Macro Problems

Share an Excel Macro-Enabled Workbook with Multiple Users

Natalie TaylorNatalie Taylor Nov 12, 2026 871 views

Question details

The user wants to know whether several people can edit and update a macro-enabled Excel workbook at the same time through cloud storage or shared workbook features.

Share an Excel Macro-Enabled Workbook with Multiple Users
Product
Microsoft Excel macro-enabled workbook (.xlsm)
Device & OS
not provided
Scenario
Multiple users need to enter or update workbook data while the workbook contains VBA macros.
Observed behavior
Excel coauthoring can support simultaneous worksheet data edits, but simultaneous editing of the VBA project is not reliably supported and can create conflicts.
Before you start

Save the workbook as an Excel Macro-Enabled Workbook (*.xlsm) and confirm that every contributor has permission to the OneDrive or SharePoint location. Decide who is responsible for maintaining the VBA code before sharing the file.

Solution 1Recommended

Coauthor the .xlsm workbook but assign one VBA code editor

Use this option when multiple users need to update worksheet values while one designated owner maintains the workbook macros.

Users can usually coauthor worksheet content in a cloud-stored macro-enabled workbook, but they should not edit VBA modules, forms, or the VBA project at the same time. Keep macro changes under the control of one person and ask other users to edit only the approved sheets and input ranges.

1
Store the workbook in OneDrive or SharePoint

In desktop Excel, select File > Save As, choose OneDrive or a SharePoint site, and save the file with the Excel Macro-Enabled Workbook (*.xlsm) format.

2
Share editing access

Select the Share button in the upper-right corner of Excel, enter the users or group, choose Can edit, and send the sharing invitation.

3
Open the file in desktop Excel

Ask contributors to open the shared workbook in the Excel desktop app and select Enable Content if the security prompt appears for trusted macros.

4
Limit VBA changes to one owner

Have only the assigned macro owner open the VBA editor with Alt+F11 and modify modules, forms, or ThisWorkbook code. Other contributors should update worksheet data only.

Coauthor the .xlsm workbook but assign one VBA code editor
Avoid simultaneous VBA edits: Cloud coauthoring does not provide reliable real-time merging for VBA project changes. If two people change macro code, one set of changes can be overwritten or cause a workbook conflict.
Free Microsoft Office alternative

Use WPS Office for Lightweight Shared Spreadsheet Work

For everyday shared spreadsheet editing, WPS Office provides a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats. You can move .xlsx workbooks into WPS Spreadsheets for routine collaboration, while testing any .xlsm VBA automation carefully before relying on it in a shared workflow.

  1. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the WPS Office home screen.
  2. 2. Open the Excel workbook: Select Open and choose the existing Excel .xlsx, .xls, or .xlsm workbook that your team needs to review or update.
  3. 3. Test workbook behavior: Check formulas, data validation, formatting, and any macro-dependent actions before asking multiple users to use the file.
  4. 4. Share the appropriate workbook: Use the Share option for routine spreadsheet collaboration, and keep VBA code maintenance assigned to a controlled owner when macros are required.
Familiar spreadsheet tools help teams move from Excel with minimal retraining.Open and edit Microsoft Excel .xlsx and .xls files with strong format compatibility.Open .xlsm macro-enabled workbooks for review and test VBA-dependent workflows before deployment.Use WPS cloud sharing features for routine spreadsheet access and collaboration.
microsoft office alternative - wps office

Frequently Asked Questions

Can multiple users edit an Excel .xlsm file at the same time?

Multiple users can often coauthor worksheet data when the .xlsm file is stored in OneDrive or SharePoint and opened in desktop Excel. However, they should not simultaneously edit VBA modules, UserForms, or other VBA project components.

Why should contributors use desktop Excel for a macro-enabled workbook?

Excel for the web does not run VBA macros. Contributors can use the web version for supported worksheet tasks, but the macro owner should open the workbook in desktop Excel and enable macros when needed.

Does the legacy Shared Workbook feature solve VBA collaboration?

No. The legacy feature is not a reliable solution for simultaneous VBA development and has feature limitations. Use OneDrive or SharePoint coauthoring for worksheet data, while assigning VBA edits to one owner.

How can I prevent users from changing the macro code?

Limit write access to the .xlsm workbook or distribute a separate data-entry workbook. You can also protect workbook structure from Review > Protect Workbook, but access control and a designated VBA owner are more important for managing code changes.

What is the best option for simultaneous data entry with automation?

Store the shared records in a Microsoft List, database, Power Apps form, or separate cloud workbook. Keep the VBA-enabled workbook as a controlled processing or reporting file that reads and updates the shared data source.