So I want to have rows hidden, and only show them if a checkbox is clicked.
All I find searching all say the same thing, EntireRow.Hidden = True/False is what give this effect, so:
Hide works like a charm. But it never stops unhiding.Sub CheckBox1_Click() If CheckBox1 = False Then [10:15].EntireRow.Hidden = True Else [10:15].EntireRow.Hidden = False End If End Sub
Google doesn't help me figure out the reason, can you?
Bookmarks