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...
--
Kevin Backmann


"Mac1" wrote:

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

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

"Mac1" wrote:

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