Password Protect Cells

[Elaine]

Hello All,

I am trying to password protect just a few cells in my worksheet. I did it
a year ago and now have forgotten what I did. The end result was that when
people went to enter data in those few cells they had to type their password,
otherwise they could not edit them.

This is different than just the worksheet password protection because I also
with a different password in addition to the individual cell protection.

Thank you for any help you can offer.

 

[Gord Dibben]

You can do this through Tools>Protection>Allow Users to Edit Ranges

Supply a range and a password for each user.


Gord Dibben MS Excel MVP

 

[Elaine]

Thank you so much for your help. I did that and it was successful on the one
worksheet I was working on. However now I can't seem to duplicate the
process again. What steps do I have to do before what you said to make it
work?

Thank you so much again for all of your help.

 

[Gord Dibben]

First protect the sheet with a password.

Then unprotect the sheet.

Then Tools>Protection>Allow users to edit ranges.

Click on "New" and set a range. You can name the range......default is Range1

Then add a password for this range and "apply"

This will be password for user1 to edit that range

Create a new range with another password for user2 etc.

Now hit the "Protect Sheet" button.

You now have a password protected sheet with password protected ranges.


Gord