I have a excel sheet on a shared drive where users run a macro and transfer some data, I had hoped the below would work if 2 or more people tried to send the data at the same time.Unfortunately it doesnt work, any suggestions so that if 2 people send at same time the first users data will be transferred and then the second person and so on. Ideally the user wont have to do anything just wait till their data has gone then get a pop up saying "data has been transferred"
If ActiveWorkbook.ReadOnly = True Then
MsgBox "The database is being accessed by another user. Please wait.... If you receive any message regarding File Reservation, please choose 'Cancel'.", , "Save Record"
ActiveWindow.Close
Exit Sub
Else
