Visual basic programs and 365

Question

Hi, I have an issue I am not sure how to work around.

I need to be able to use both Visual basic modules/macros AND have multiple users able to use and edit the sheet simultaneously.

From what I understand, you can't make 365 run the visual basic modules, and the physical excel app cannot support simultaneous editing.

Is there any way to do what I need? is there a version of the program of the that does both things I need? or some trick to a version of the excel desktop app that allows simultaneous editing?

Thanks

Answer 1

Hello Michael Albert (Student)

Welcome to the Microsoft Community.

Based on your description, it seems that you need to find the version of Office that supports both multi-person online editing and the use of macro settings. Please correct me if I have misunderstood.

At this point in time, there is no such version that meets both of your requirements.

Since macros call on the device's local resources, which inevitably leads to security risks, adding macros to an online version that allows multiple editors would result in a possible risk to all editors' devices. This is a challenging feature, but undoubtedly an extremely user-friendly one, and I hope Microsoft has plans to roll it out.

Thanks for your patience and understanding! 

Best wishes

Mark . Li - MSFT | Microsoft Community Support Specialist

Answer 2

Hello, Michael Albert (Student)

You're correct that there are limitations with using Visual Basic for Applications (VBA) in a shared, collaborative environment like Excel for Microsoft 365. Here are some insights that can explain:

Excel Online (part of Microsoft 365) does not support running VBA macros. This means any automation or complex logic you’ve built with VBA won’t execute in the online environment. It mainly relies on online services, and the VBA editor is not suitable for use on Excel for Web. This is a security issue. Any unknown user who intends to infringe on other people’s devices may use the execution of macro codes to implant macro code viruses in the computer.

Therefore, this function may be more suitable for experienced users to complete, if you prefer this file to be updated online and synchronized. Please temporarily refer to using Office Scripts, which allows multiple users to edit online and complete the automation you need (temporary mitigation solution) Please refer to:

Introduction to Office Scripts in Excel - Microsoft Support

Platform limits and requirements with Office Scripts - Office Scripts | Microsoft Learn

Feel free to let us know if anything unclear, thanks!

Chandy.L

Answer 3

Hello Michael Albert (Student)!

Seeing that you gave me a "no" rating, I need to understand why.

Usually, if the support staff provides valid information or solutions, we want to get an accurate rating, which will help us to go back to the archives and motivate more users with the same query to locate here.

In addition, we also highly recommend you to use the dedicated feedback platformIdeas-Community (microsoft.com)(English platform), where specialized developers will pay attention to your feedback and comment on it. After sending your feedback, you can share the feedback link in this forum so that other users with similar issues, including me, can vote for your feedback; the more votes you get, the more likely you are to get the attention of the development team. The more votes you get, the more likely you are to get the attention of the development team.