Hide/unhide row using check box PLEASE HELP****

[madaleck1]

Hi,

New to excel so still trying to learn.

I want to be able to hide/unhide an entire row using a check box.

Does anyone have a macro i can assign to the checkbox.

I need to hide row 54 in sheet 4.

Thanks for your help

 

[Andrew Poulsom]

Using a CheckBox from the Control Toolbox, this will toggle the visibility:

Private Sub CheckBox1_Click()
    Worksheets("Sheet4").Rows(54).Hidden = CheckBox1.Value
End Sub

 

[madaleck1]

Using a CheckBox from the Control Toolbox, this will toggle the visibility:

Private Sub CheckBox1_Click()
    Worksheets("Sheet4").Rows(54).Hidden = CheckBox1.Value
End Sub

It's not working unfortunately