Restrict User to specific cell
 

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

Restrict User to specific cell
 

Select that cell

FormatCellsProtection, and unclick Locked

Protect the sheet, ToolsProtectionProtect sheet...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Restrict User to specific cell
 

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Restrict User to specific cell
 

Typo correction, line:
("locks" only cell B5)

should read:
("unlocks" only cell B5)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---