Hi,
this may be a very quick question...
Using the Control Toolbox, I have a single checkbox on each sheet of a 56
sheet workbook. if that sheet is "completed" the checkbox is to be checked.
Now i have a summary sheet that shows what sheets are "Completed" how do i
write a cell function that will put yes or no depending on the true/false of
the checkbox? Thanks!

this is a sample of my summary sheet
something like this:

A B
sheet1 =IF(sheet1.checkbox1, "yes", "no")
sheet2 =IF(sheet2.checkbox1, "yes", "no")
sheet3 =IF(sheet3.checkbox1, "yes", "no")