Protect the formula but change result.

Hello,

In a worksheet I calculate a sum with SUMIF function. It adds up
corresponding numbers if selected by an "X" in a group of cells.

I want to protect the numbers and the summation cells (for accidental
damages to formulae) with a password but when I send the worksheet to
colleagues I want them to manipulate the sum by adding or removing "X"s.

How can I do that?

Thanks
Archie

Archie,

You can protect a set of cells.

First, goto Format>Cells>Protection, and uncheck the Locked box
Then select the cells to protect
First, goto Format>Cells>Protection, and check the Locked box
Go to Tools>Protection and set worksheet protection.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ArchieBoy" <[email protected]> wrote in message
news:[email protected]...
>
> Hello,
>
> In a worksheet I calculate a sum with SUMIF function. It adds up
> corresponding numbers if selected by an "X" in a group of cells.
>
> I want to protect the numbers and the summation cells (for accidental
> damages to formulae) with a password but when I send the worksheet to
> colleagues I want them to manipulate the sum by adding or removing "X"s.
>
> How can I do that?
>
> Thanks
> Archie
>
>