I have a workbook consisting of ten worksheets that is in a shared folder and
which is accessible by 200 staff. I would like to make it read only to 180 of
those staff and editable by the remaining 20.
It has to be available to all staff at all times. I expect the answer is
read/write permissions but I'm not sure how to go about this - I did look in
Help but it appears that I need to download software which would not be
possible.
Any suggestions would be gratefully received.
Thanks

An alternative read/write permissions at the O/S level is to require a
password to open the workbook in read/write mode. You apply it as follows:
Save As, Tools, General Options
This dialog gives you the option of entering two passwords - one for
read-only, the othe for read/write. You might want to leave the read-only
password blank, so all users can view the workbook, and enter just the
read/write one, which you would reveal to the users in the privileged group.
--
TedMi

"Arceedee" wrote:

I have a workbook consisting of ten worksheets that is in a shared folder and
which is accessible by 200 staff. I would like to make it read only to 180 of
those staff and editable by the remaining 20.
It has to be available to all staff at all times. I expect the answer is
read/write permissions but I'm not sure how to go about this - I did look in
Help but it appears that I need to download software which would not be
possible.
Any suggestions would be gratefully received.
Thanks

Brilliant - works a treat! Thanks

"tedmi" wrote:

An alternative read/write permissions at the O/S level is to require a
password to open the workbook in read/write mode. You apply it as follows:
Save As, Tools, General Options
This dialog gives you the option of entering two passwords - one for
read-only, the othe for read/write. You might want to leave the read-only
password blank, so all users can view the workbook, and enter just the
read/write one, which you would reveal to the users in the privileged group.
--
TedMi

"Arceedee" wrote:

I have a workbook consisting of ten worksheets that is in a shared folder and
which is accessible by 200 staff. I would like to make it read only to 180 of
those staff and editable by the remaining 20.
It has to be available to all staff at all times. I expect the answer is
read/write permissions but I'm not sure how to go about this - I did look in
Help but it appears that I need to download software which would not be
possible.
Any suggestions would be gratefully received.
Thanks