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.

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

Hi Dave,
Thanks for the help.

I agree it would be more simple to keep all the info in one sheet but I need
to be able for each department to readily go into their checklist tab and see
what items remain open and need completion. The master list with checkboxes
is for my sanity so I don't have to check 29 plus checklist for completion. I
guess I better start assigning links.

Thanks again for your help.
Trese
"Dave Peterson" wrote:

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