Sorted it, we had locked the cell that held the TRUE/FALSE value. Unlocking
that and hiding it has solved it.



"gibbylinks" wrote:

Help Panic...... All went well until we tried to protect the cells. Then it
doesn't work, is there a way around this ??

Using Exel 2000

"gibbylinks" wrote:

Thanks

Got it working.

Paul

"Bob Phillips" wrote:

If you use a tick in a cell, it is easy. Assume that the cell is A1, to get
a tick, form at as Marlett, and enter a. Then in another cell
=IF(A1="a","some text","")

--

HTH

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


"gibbylinks" wrote in message
...
Is it possible to put text in a cell, if a check box is ticked somewhere
else
on the spreadsheet ? but leave it blank if nothing is ticked.

Cheers

Paul