setting workbook read only except for one user

  • Thread starter Thread starter scott.streit
  • Start date Start date
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?
 
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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top