The Checkboxes collection are for checkboxes from the Forms toolbar.

JLGWhiz wrote:

TextBox or CheckBox? Be sure your control name is correct:

"Check Box 1" and "CheckBox1" are two different names

CheckBoxes is not a collection, but OLEObjects is.

Or ActiveSheet.CheckBox1 = True will also work.

"newguy" wrote in message
...
I am trying to use a form control text box to hide tabs in a worksheet
and I cant seem to get it to work any suggestions.
Sub CheckBox_Click()
If ActiveSheet.CheckBoxes("Check Box 1").Value = 1 Then
Sheets("Sheet2").Visible = False
Else
Sheets("Sheet2").Visible = True
End If
End Sub

--

Dave Peterson