All I need is for the following code to work. Should be simple;

PHP Code:
Private Sub Worksheet_Calculate()

For Each cell In Range("W7:W17")
If cell.Value = "Payment Not Required" Then
ActiveSheet.CheckBoxes("Check Box 58").Visible = True
Else
ActiveSheet.CheckBoxes("Check Box 58").Visible = False
End If
Next
If cell.Value > 0 Then
ActiveSheet.CheckBoxes("Check Box 61").Visible = True
Else
ActiveSheet.CheckBoxes("Check Box 61").Visible = False
End If
End Sub

As ever, any help would be greatly appreciated. Upon a successful amendment any further guidance on how to expand the solution to contain other conditions (If's and else's) would also be of use in a bid to learn and be more self sufficient.

Thanks,

Glen