Morning all, I have set up a user form to appear and have set it up as follows
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Me.Range("K44") And Me.Range("K49") > 0 Then
AWPI.Show
End If
This does work but the problem being the form activates...