Allowing input in only one cell

[Wismer]

Hi,

Is there a way where I can protect the full worksheet but allowing only one cell for inputing data?

For Example: user can input Yes in cell B2 while the rest of the worksheet is all protect and does not allow any input.

Thanks
Wismer

 

[schwede]

Wismer,

try selecting the cells which should allow input, press Ctrl+1 (format cells) and uncheck "locked" in the protection tab. Then you must protect the worksheet: Tools>Protection>Protect Sheet. Unselect "Select locked cells". Optionally, you can set a password.

 

[Wismer]

Right on. thanks.

Also can I limit the input in that Cell to only Yes? I tried to use data validation after the steps you mentioned but data validation options are grey( not available)

Any advice.

Thanks
Wismer

 

[lenze]

Schwede's suggestion is probably best, but you could use code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address <> "$B$2" Then Range("$B$2").Select
End Sub

This would only allow then to select B2

lenze

 

[Oaktree]

You have to apply the data validation before you protect the sheet.

Unprotect it and, apply the validation, and reprotect.

 

[Wismer]

You guys are like Hawks.
So quick so accurate...right on.

Great job guys
Keep it up.

Peace Wismer