Multiple User Macro Sheet

[aarongoad]

I am trying to create a workbook that uses macros that multiple people could use and update in real time. When I share with a coworker to test, it shows up saying "failed to upload" or could not save because someone else is editing. Is there any way to get this to work or do I need to do it on Google Sheets?

[#2]

I assume they are not editing the VBA code?

[#3]

Correct. Just need them to be able to click the active x box to run the macro.

[#4]

It might work better using Office Script: https://jkp-ads.com/articles/excel-office-script-basics.asp
What VBA code needs to run on the click of that button and what does it do precisely?

[#5]

@Jan Karel Pieterse here is a copy of the file. The button changes colors, puts in a text box for the user to insert information, and puts a time stamp. When clicked again the button changes colors, clears the text below, and puts the information in a log that is in the second tab. 

[#6]

Also upon investigation, I am unable to access the admin center to get to Office Script. Unfortunately, this would not be a viable option in my scenario.

[#7]

https://answers.microsoft.com/en-us/msoffice/forum/all/qr-codes-in-access/09b766d2-a759-470a-86bb-f4...


Looks like this security log.
re:
When I share with a coworker to test, it shows up saying "failed to upload" or could not save because someone else is editin

When relative to multi-users,I prefer database as backend which olny locks one row when insert a record rather than Excel locks whole file.