I have inserted some code as below on a sheet in my workbook called "Implementation". When the checkbox is ticked it hides/unhides rows. It does this but also unfortunately it throws up a debug error which I can't seem to get rid of. Very frustrating! I had it working fine before when it was called "Sheet1" and I'm not a programmer so dunno what i'm doing really! I tried using "ActiveSheet" instead of Sheets("Implementation") too but the resulting error was the same. Help!
![]()
Private Sub CheckBox18_Click() Rows("40:42").Select If CheckBox18.Value = True Then Selection.EntireRow.Hidden = False Sheets("Implementation").CheckBox19.Visible = True End If If CheckBox18.Value = False Then Selection.EntireRow.Hidden = True Sheets("Implementation").CheckBox19.Visible = False End If Range("$A$32").Select End Sub
Bookmarks