Software

Ask something
Discussion Locked

Protection

0 helpful
9 replies

by jacmari

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I go about protecting Excel worksheets? I have 6 worksheets in a workbook. 5 of the worksheets can be viewed by everyone in the network but only edited by 2 users. How do I go about protecting the sheets?

Thank you in advance.

9 replies

by jbond007

Depending on your version of excel you should be able to password protect your worksheet and/or workbook.

Look for the option under tools.

regards,

jb

by jacmari

Already tried this method. My boss wanted another way of doing it. Thanks for your input.

by dennisbv

In Excel 2000 if you goto Tool-Protection you can password protect a sheet. Or you can share the woorkbook and track changes.

by jacmari

I already tried this method but my boss wanted another way of doing it if possible. Thanks though.

by dklippert

Depending on the type of network, you could assign rights to classes of users. While all could read the file, only the "admin" class would have write privileges. The 6th sheet would be protected/hidden.

by jacmari

I really like your answer but you think you could give me instructions as how to do that?? Right now, we're using Windows 2000. I don't know if that answers your question as to our type of network. Sorry bout that.

If it's not a problem, couldyou be more specific? Thanks.

by dklippert

Talk to your network administrator. You can place the file in a folder that grants Read Only permission to everyone, and Change permission to a defined group.
Or you can set this up yourself, if you have Admin privileges, by right clicking the folder that contains the Excel file and choosing Sharing. Click on the Permissions button. Grant Everyone Read permissions only. Then Add other users with Change Permissions.

This discussion is closed to new replies.