Can you write-protect one cell at a time?

Is it possible to write-protect ONE cell at a time?

Thank you
Ann

You can lock or unlock any cell (format|cells|protection tab)

And when you protect the worksheet (Tools|Protection|Protect sheet), the locked
cells won't be able to be changed by the user.

But this worksheet protection is easily broken. So it's not made to protect
intellectual property.

And there are lots of things that can't be done to a protected worksheet, you'll
want to test it to see if you're happy.

aletoconstco wrote:
>
> Is it possible to write-protect ONE cell at a time?
>
> Thank you
> Ann
>
> --
> aletoconstco
> ------------------------------------------------------------------------
> aletoconstco's Profile: http://www.excelforum.com/member.php...o&userid=35336
> View this thread: http://www.excelforum.com/showthread...hreadid=572892

--

Dave Peterson

Ann

By default all cells on a sheet are locked when the sheet is protected.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked" and OK

Now select the sections/rows/cells to protect and Format>Cells>Protection.
Check "locked" and OK

Tools>Protection>Protect Sheet

The section/row locking does not work if you don't protect the sheet.


Gord Dibben MS Excel MVP

On Thu, 17 Aug 2006 19:27:44 -0400, aletoconstco
<[email protected]> wrote:

>
>Is it possible to write-protect ONE cell at a time?
>
>Thank you
>Ann

Gord Dibben MS Excel MVP