Worksheet locked for editing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My daily roster worksheet is on a shared drive and accessed by up to 40
people on a 24 hour basis.
First one to open it automatically locks it and others ,including myself,
have 'read only' access. I need to edit this roster several times a day. Can
I configure this worksheet to allow myself only to have 'locked for editing'
permission and all other users 'read only' access.

Thanks

Mac
 
Click TOOLS on the menu and select SHARE WORKBOOK and on the EDITING tab of
the dialog box, check the ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME
TIME to on.

However, shared workbooks come with their own set of quirks, problems and
issues. You might consider using Access in a multi-user environment,
especially with the number of users you mentioned as being as many as 40.

Good luck...
 
If you're the only one who should edit the file, I'd put a password on the
file. To do that, go to File > Save As. In the dialog, select the 'Tools'
drop-down on the top right and select General Options. Enter a password to
modify and check 'Read Only Recommended.'
When your users open the file, they'll be prompted for a password; they
should select to open the file read only. You, of course, will enter the
password and decline the recommendation to open the file read only.
--Bruce
 
Back
Top