Private Sub Worksheet_Change(ByVal Target As Range)
If Range("d17").Value > 0 Then
Application.EnableEvents = False
Range("a5:o17").Select
Application.EnableEvents = True
End If
End Sub
Hi Im using the above code which worked a few times the stopped woking,
the select is just a test to see if worksheet change is working. I put
a break point at private sub, but its not getting fired each time
theres a chnge in the worksheet. Any suggestins.
Regards Robert