title: How can multiple users run macros on a shared excel file?
body: <p>I have an excel file on shared location where multiple users (4 in this case) are accessing the file at the same time. </p>
  
  <p>This file has a “Master data” tab where all the base data is there and then there are 4 identical tabs (one for each user). </p>
  
  <p>Each user tab has a set of filters using which the user will be able to extract relevant data based on the filters selected and can add or edit the rows. Once the user is done editing/adding rows, user will submit the data which will get updated/appended in the master data tab. </p>
  
  <p>Users can select same or different options in the filters. I am facing errors when multiple users click on the submit button (macro) at the same time. </p>
  
  <p>How can I resolve this?</p>