Hey everyone,
This is a real long shot, but will help me out massively...
I have a workbook (used by more than one user) which sets itself to read only upon closing. When I open it I have a log in screen which pops up, the user has the choice to go into "edit mode" or "information only" mode. When the user selects the "edit mode" the workbook switches to write access for that user. However, this does not prevent someone else from going into "edit mode" at the same time (granting them write access) and potentially causing conflicts.
Is there a way that I can allow the first person who wants to go in "edit mode" to have write access, then for everyone else to not be allowed write access until that user closes the workbook (therefore returning the workbook back to read only)?
Many thanks,
LSM1604
This is a real long shot, but will help me out massively...
I have a workbook (used by more than one user) which sets itself to read only upon closing. When I open it I have a log in screen which pops up, the user has the choice to go into "edit mode" or "information only" mode. When the user selects the "edit mode" the workbook switches to write access for that user. However, this does not prevent someone else from going into "edit mode" at the same time (granting them write access) and potentially causing conflicts.
Is there a way that I can allow the first person who wants to go in "edit mode" to have write access, then for everyone else to not be allowed write access until that user closes the workbook (therefore returning the workbook back to read only)?
Many thanks,
LSM1604
