Macro to open workbook with read only error

[dsrt16]

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.

Please Login or Register  to view this content.

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.

[Leith Ross]

Hello dsrt16,

You don't really provide enough detail about this master workbook. Is it a shared workbook? Is it stored on a network server? If it is shared, what options have you set for sharing it?

[dsrt16]

THe master document is on a shared network. There is one master per grade level. The master is used to find the points that teachers have assigned students throughout the day (using the vlookup formula and referncing individual teachers spreadsheet)and it stores all the points on one spreadsheet. Then when a teacher has the master updated, their indivdiual class spreadsheet has a table for their last period class that references the master and gets the points a certain student receievd in each period.

Example: I have attached the math 8 spreadsheet; as you can see the last period (intervention class) returns students points read off the master.