AUTOMATICALLY CLEARING CHECKED BOXES

[cdnqte]

I have a spreadsheet that is designed to randomly assign groups of 4. In this sheet there are a group of 35 check boxes of which can have 24 checked at any given time. I would like to clear these boxes and set the linked cells to FALSE each time the sheet is open. Is there a way to record a macro that will clear the check boxes upon request?

 

[Chas17]

assumptions:
1. you are using check box from Forms toolbar
2 linked cells for check boxes are in E1:E35

Place a button on worksheet, place this code in module for button

Sub Button4_Click()
Dim i As Integer

For i = 1 To 35
    Cells(i, 5) = False
Next i

End Sub

You could also place code in worksheet open event.
Chas

 

[cdnqte]

Wonderful! One more question (I am an amature at this..)

In that code, how do I determine which sheet? The "Clear All" button is on the main page but the data is actually on a separate sheet.

Thanks so much for your help!

 

[cdnqte]

Actually, I just answered my own question...

Thanks again for your help..