Restrict User to specific cell

M

MauraLae

I would like to run a worksheet where the user is only allowed to input
data in a specific cell, ...say B5.
 
B

Bob Phillips

Select that cell

Format>Cells>Protection, and unclick Locked

Protect the sheet, Tools>Protection>Protect sheet...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
M

Max

[email protected] said:
I would like to run a worksheet where the user is only allowed to input
data in a specific cell, ...say B5.
Click to expand...

Assume we want to unprotect just this cell in the whole sheet

Try this sequence ..
Select cell B5
Format > Cells > Protection tab > Uncheck "Locked" > OK
("locks" only cell B5)

Then apply sheet protection via:
Tools > Protection > Protect Sheet > Passwrd? > OK

Test it out. All cells on the sheet, other than cell B5,
will be locked / protected.
 
Top