Please could someone help me with below code, essentially it hides two command buttons if a value in a cell is over 183.
It works when I type a number into the cell (K4), but its going to be linked to another cell on another sheet, so it contains the formula ='3'!$L$3.
Doesn't work when it's sent up this way? Code below.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("K4").Value <= 183 Then
CommandButton21.Visible = True
Else
CommandButton21.Visible = False
End If
If Range("K4").Value <= 183 Then
CommandButton22.Visible = True
Else
CommandButton22.Visible = False
End If
End Sub
Thanks
Bookmarks