Hiding rows, but checkboxes aren't hidden

**kid_epicurus** · 04-19-2012, 11:55 AM

I'm using VBA to hide certain rows when a checkbox is clicked. It appears to work ok, but It's leaving a checkbox behind.

checkbox.png

Here is the code I'm using. Maybe RowHeight isn't the best route?

Private Sub Rows_Collapse_Click()
    If Rows_Collapse.Value = True Then
        Me.Range("C92:I95").RowHeight = 0
    Else
        Me.Range("C92:I95").RowHeight = 17
    End If
End Sub

**Mordred** · 04-19-2012, 12:13 PM

Hi kid, this is not tested but try

Private Sub Rows_Collapse_Click()
    If Rows_Collapse.Value = True Then
        Me.Range("C92:I95").EntireRow.Hidden = True
    Else
        Me.Range("C92:I95").EntireRow.Hidden = False
    End If
End Sub