Linking Check Boxes

N

Nightshade

I have a set of check boxes on one tab, and another on the next tab. Is
there anyone to link them together so if one is checked off the other ones is
as well?

Thank you
 
T

T. Valko

Assign all the check boxes to the same linked cell.

For example, make the linked cell Sheet1A10
Give this cell a defined name:
Insert>Name>Define:
Name: LinkCell
Refers to: =Sheet1!$A$10
OK

Now, set the linked cell for each check box to be LinkCell
Right click the check box
Select Format Control
Cell Link: LinkCell
OK
 
N

Nightshade

Perfect. Thank you

T. Valko said:
Assign all the check boxes to the same linked cell.

For example, make the linked cell Sheet1A10
Give this cell a defined name:
Insert>Name>Define:
Name: LinkCell
Refers to: =Sheet1!$A$10
OK

Now, set the linked cell for each check box to be LinkCell
Right click the check box
Select Format Control
Cell Link: LinkCell
OK
Click to expand...
 
Top