Protect the formula but change result.

[ArchieBoy]

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

 

[Bob Phillips]

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)