"read only" cell in a given worksheet

[Colin2u]

is it possible to have a particuler cell in a worksheet to be only "read
only"? meaning to hae that cell be read and not to be edited be others (even
preventing the view of that cell's formula).
thank you.

[Doug Kanter]

"Colin2u" <Colin2u@discussions.microsoft.com> wrote in message
news:FAAE5C9B-ADF9-4AD4-AA6B-4688684ABCB9@microsoft.com...
> is it possible to have a particuler cell in a worksheet to be only "read
> only"? meaning to hae that cell be read and not to be edited be others
> (even
> preventing the view of that cell's formula).
> thank you.

Click on Format, Cells, and then look at the Protection tab. You'll see two
options: locked and hidden, along with a brief explanation of what's what,
as well as the limitations of the features. This may or may not do what you
need.

[Phil]

But don't forget that you need to protect the worksheet before the
locking actually happens.

Phil