Macro to open workbook with read only error

I have coded a macro assigned to a submit button, which submits period one's points and uploads them to the master and saves the spreadsheet; there is only one problem everyone is uploading to the master at the same time, so the document would be read only.


Am I right in assuming if an individual has the master open all day, she will not get the changes from the other teachers becasue she has the "old copy" open and not the new updated copy? Because I believe this to be true, I have the code close out of the master.

To get around the problem of teachers forgetting to save or openng the master too early, I created this code, but the problem is it will work for whoever presses submit first, but everyone else willl have a read only version of the master (since someone else may have it open at the same time), and then the changes can not be saved.

Sub Submit

ActiveWorkbook.Save
'Save teacher's indivdiual spreadsheet'

Workbooks.Open "pathway to the master", UpdateLink:=3
ActiveWorkbook.Close SaveChanges:=True

A teacher would press submit at the end of every period, but the problem again lies in those getting a read only version of the master.

I got around this before becasue I was telling all the teachers to open the master at a certain time, and it didn't matter if it was read only because they didn't need to save it, they just needed to update the links (the changes that had occured throughout the day) so it would update their individual spreadsheet and read the points after the master. Then they could close out of the read-only version of the master without saving.

But, I have teachers who can't remember to save, and who open the master too early, and then they are all calling me trying to figure out why their spreadsheet shows 0's instead of updated points, so I am trying to make it all happen automatic with few steps needed from the user.