Protect/Lock Specific Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to protect or lock certain cells of a worksheet. I
only want our directors to be able to access these cells. How do I do that?
 
It doesn't look like it's possible to do what I'm looking for. I want other
users to be able to utilize the sheet, but not be able to change these two
cells, so I don't want to protect the whole thing. I only want certain
people to change those two cells by using a password. Thoughts???
 
Select all the cells except the ones you want protected, then go to format -
protection and unlock the cells. Then, go to tools - protection and protect
the work sheet. That will protect only the two cells you want.
 
If you're using xl2002+, then you can use some of the protection options to
allow users to edit ranges on protected worksheets.
 

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

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Protecting a Sheet 7
Sheet Protection 3
Lock specific cell 1
Unprotecting worksheets 2
Locked cells are still able to be selected with proper protection 1
Cell Protect 1
Need to lock 2 rows in a sheet 1

Back
Top