Hi guys

I have searched through the forum a few times but can't find my solution.

I am trying to build a sheet where, upon opening the sheet, rows (say 5 to 10, then 11 to 15) are hidden.

The user will have two checkboxes to choose from.

When checkbox 1 is selected, rows 5 to 10 are unhidden. If checkbox 1 is clicked again, rows 5 to 10 disappear again.

Checkbox 2 unhides and hides rows 11 to 15.

The code for the opposite of this scenario (hides rows when selected) is as follows:

Sub CheckBox1_Click()
With Rows("5:10")
        .Select
       .EntireRow.Hidden = Not .EntireRow.Hidden
    End With

End Sub
I have tried recording the scenario on excel, but so far have had no success. I'm sure this is ridiculously easy for someone out there...

Thanks for reading, please reply if you have any good ideas!