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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,176,219
Messages
5,901,971
Members
434,932
Latest member
banter

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