selective protection

Hi,

excel 2002 (10.6789) sp3 office XP


is it possible to protect some cells on a sheet?


I have a sheet that I want users to enter data into some cells and other
cells (which have formula in them) will display the results.

I want to protect, if that is the correct terminology, the cells with
the formula so it they don't get deleted or modified by mistake.


The protection option just protects all the cells so data cant be added.

Or I'm I trying to do something that is impossible?

Thanks for any help.


--
Nospam

that is correct, the default value of the Locked property of each cell is set
to True.

Try selecting the cells you want unlocked (with the worksheet unprotected)
and unchecking the locked property in Format=>Cells=>Protection tab. Then
protect the sheet.

--
Regards,
Tom Ogilvy


"Nospam" wrote:

> Hi,
>
> excel 2002 (10.6789) sp3 office XP
>
>
> is it possible to protect some cells on a sheet?
>
>
> I have a sheet that I want users to enter data into some cells and other
> cells (which have formula in them) will display the results.
>
> I want to protect, if that is the correct terminology, the cells with
> the formula so it they don't get deleted or modified by mistake.
>
>
> The protection option just protects all the cells so data cant be added.
>
> Or I'm I trying to do something that is impossible?
>
> Thanks for any help.
>
>
> --
> Nospam
>

In message <1E3F45E5-C3ED-4640-9ECD-588BBD341E0F@microsoft.com>, Tom
Ogilvy <TomOgilvy@discussions.microsoft.com> writes
>that is correct, the default value of the Locked property of each cell is set
>to True.
>
>Try selecting the cells you want unlocked (with the worksheet unprotected)
>and unchecking the locked property in Format=>Cells=>Protection tab. Then
>protect the sheet.
>


Thanks, just what I was after.

--
Nospam