Share an Excel Macro-Enabled Workbook with Multiple Users
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.

- 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.
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.
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.
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.
Select the Share button in the upper-right corner of Excel, enter the users or group, choose Can edit, and send the sharing invitation.
Ask contributors to open the shared workbook in the Excel desktop app and select Enable Content if the security prompt appears for trusted macros.
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.

Separate shared data entry from the macro workbook
Use this approach when many users need real-time data entry but only a limited number of people need to run or maintain automation.
Use a collaborative data platform instead of a shared VBA workflow
Choose this solution when the process requires frequent simultaneous updates, approvals, forms, or multi-user automation beyond spreadsheet data entry.
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. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the WPS Office home screen.
- 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. Test workbook behavior: Check formulas, data validation, formatting, and any macro-dependent actions before asking multiple users to use the file.
- 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.

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.




