Hide/visually block sections of a spreadsheet based on a checkbox?

[Zylet]

For example, if I make a checkbox labelled "N/A", and it's checked, rows 40-50 will have some visual indicator that they're N/A (e.g. partially transparent window, line out).

If it's not possible with a checkbox, is there another way to do it?

[modytrane]

See attached example.
You can change the Rows selection from "5:8" to other range.
Hope this helps.

Sub Hide()
'
'

'
    If ActiveSheet.Range("B1").Value Then
    
        Rows("5:8").Select
        With Selection.Interior
            .Pattern = xlSolid
            .PatternColorIndex = xlAutomatic
            .ThemeColor = xlThemeColorDark1
            .TintAndShade = -0.499984740745262
            .PatternTintAndShade = 0
        End With
        Rows("5:8").Select
        With Selection.Font
            .ThemeColor = xlThemeColorDark1
            .TintAndShade = -0.349986266670736
        End With
    Else
        Rows("5:8").Select
        With Selection.Interior
            .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
        With Selection.Font
            .ColorIndex = xlAutomatic
            .TintAndShade = 0
        End With
    End If
    
    Range("B10").Select
End Sub