Upon Opening, Is WB already open and in write mode?

LSM1604

New Member
Joined
Jan 8, 2010
Messages
49
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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,141,842
Messages
5,708,916
Members
421,598
Latest member
NewHere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top