Re:http://www.excelforum.com/excel-prog...el-2007-a.html
ChemistB; This code will hide the rows and the checkbox when your first checkbox is checked and will unhide them when it is not checked.
Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Rows("34:35").Hidden = True
ActiveSheet.Shapes("Check box 1").Visible = False
ElseIf CheckBox1.Value = False Then
Rows("34:35").Hidden = False
ActiveSheet.Shapes("Check box 1").Visible = True
End If
Hi,
ChemistB
I am reading your post and can't help but to ask if this can be modified for multiple check-boxes ?
What do you think...
Thank's
Bookmarks