Restrict User to specific cell

[MauraLae@gmail.com]

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

[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)

<MauraLae@gmail.com> wrote in message
news:1145830849.114642.215950@u72g2000cwu.googlegroups.com...
> I would like to run a worksheet where the user is only allowed to input
> data in a specific cell, ...say B5.
>

[Max]

"MauraLae@gmail.com" 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
---

[Max]

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

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