Auto unhide rows if formula returns a value >0

Hello Thalassa (and anybody else who reads this)

Thank you for a really speedy response. I've tried it, but it appears to be continually looping. I've had another idea. On the "Module Summary" worksheet I have already created activeX checkboxes which hide and unhide worksheets.

Here is a code for one of the checkboxes:

Private Sub CheckBox59_Click()
If Sheets(CheckBox59.Caption).Visible = xlHidden Then
Sheets(CheckBox59.Caption).Visible = -1
Else
Sheets(CheckBox59.Caption).Visible = xlHidden
End If
End Sub

Is there a code I could add to each of the 59 Checkbox codes which is a VBA Code on a worksheet called "Module Summary" to unhide a line within the "RESULT LINE GRAPHS" worksheet when the checkbox is ticked?

Checkbox 1 when ticked would unhide Row 40 in "RESULT LINE GRAPHS" Sheet
Checkbox 2 when ticked would unhide Row 41 in "RESULT LINE GRAPHS" Sheet
Checkbox 3 when ticked would unhide Row 42 in "RESULT LINE GRAPHS" Sheet
and so on...........

But, if the checkbox is unticked to hide the row again.

Kindest regards