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?

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?

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?

Just have a macro assigned to Checkbox1 and then deleting rows is irrelevant

Sub Checkbox1_Click()
With ActiveSheet
If .CheckBoxes("Check Box 1") Then
.CheckBoxes("Check Box 2").Value = True
End If
End With
End Sub


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sparky13" wrote in message
...
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?