Cell Locking Question

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I have a feeling that this isn't possible, but I'll ask the question
anyway. Is there a way to lock cells but allow certain information to
be entered or changed, but not other information. For instance if the
possible entries into the cell are A, B and C, is it possible to allow
anyone to enter A or B, but only users with a password to enter C.

If this isn't possible using cell locking, is there another way to
work around it? Any help is greatly appreciated.
 
There's a couple ways this might be accomplished. Give this a try:

Set up a new cell somewhere where your user can enter a password into. I'll
just use B1 for an example. Then, set up your possible data values in a
list. For example, in cells A1:A3. Use the following values.

A1 A
A2 B
A3 =IF(B1="Password","C","")

Set your Data Validation to accept a "List" and choose cells A1:A3 to
populate that list. Note that the List of valid entries will only include
"A" or "B" unless the user has typed in the correct password into cell B1.
Then, "C" becomes a valid entry. Just make sure that the password field is
cleared whenever the users are done entering data (this could also be
accomplished automatically with a VBA BeforeSave event).

You'll also want to set cell A3 up with a "Hidden Formula"
(Properties-->Protection-->Hidden) so that users won't be able to find out
the password by simply selecting that cell. Or, place your data list on a
separate worksheet, then hide that sheet.

HTH
Elkar
 
Data Validation on the cell can be used to restrict the entry to A, B
or C, but I'm not sure how you could apply a password facility on top
of that.

Pete
 
Back
Top