setting workbook read only except for one user

S

scott.streit

I have a sheet that I want to share with co-workers but I only want
them to have read only access.

If I put the file on the public server it will give the frist perons to
open it full access and readonly to everyone there after.

What is the best way to go about this?
 
H

Harlan Grove

I have a sheet that I want to share with co-workers but I only want
them to have read only access.

If I put the file on the public server it will give the frist perons to
open it full access and readonly to everyone there after.

What is the best way to go about this?
Click to expand...

The best way to go about this is to use the server's operating system (OS)
to do what it was desinged to do - handle different file access levels for
different users. If you have an IT department, get someone in it to show you
how to set your personal (i.e., your user ID's) permissions to this file to
Full Control and all other users' permissions to Read Only. That's far &
away the best way to do what you describe above.
 
Top