Assign all the check boxes to the same linked cell.

For example, make the linked cell Sheet1A10
Give this cell a defined name:
InsertNameDefine:
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

--
Biff
Microsoft Excel MVP


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