The other users have a nasty habit of adding / deleting rows / columns and
moving things around. In some cases this is necessary so I can not proyect
the worksheet. Additional information: There are a number of cells linked to
check 1 box but only one cell that dependes on the status of check box 2. I
want the chack box 2 to: 1) Indicate the status of check box 1 yet be able to
override it when necessary.

"Bob Phillips" wrote:

You will struggle without VBA. How will the break it if there is VBA?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sparky13" wrote in message
...
My spread sheet contains (2) check boxes (forms type) that I need to link
in
the following manor. If I tick box 1 than box 2 needs to check. That I can
do
with linking both boxes to the same cell using format control. What I need
to
be able to do tick box 2 with out it effecting box 1. I can not do this
with
programming through VBA or anything else because the other users will
break
the spreadsheet.
Question: Can I link a check box to two cells with format control?