I like to use the controls from the Forms toolbar--just because they seem to
behave better when I use them.

And I don't like duplicating data across worksheets. I'd do my best to keep
them all on one worksheet.

But if you really need to have them on different worksheets, you could assign
the same linked cell to each of the checkboxes that represented the same option.

I created a workbook with 3 worksheets.

I put a few checkboxes on each sheet. But I assigned the same linked cell to
each pair of checkboxes: Sheet3!a1, sheet3!a2, sheet3!a3, etc.

I'd use column B to put a description of what each meant--it could get
confusing.

Trese wrote:

Hi all,
I have a very large workbook with many tabs(each tab is a checklist with
check boxes that was pulled from the main sheet according to an ID that was
given to each line item).
What I am trying to do is once the checkbox on the checklist tabs are
checked I need the checkbox on the main sheet to automatically show checked
as well for checked items.

Is this possible?
Does it matter which checkbox toolbar I should use. (Control toolbar or
Forms toolbar). I am currently having trouble inserting the control toolbar
checkboxes through ROW 2000 on each tab. I lock up and can't save.

--

Dave Peterson