worksheet change
 

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

worksheet change
 

Ignore the post, Im an idiot. Id put a break at range selection. The
stopped running the macro, before it enabled the events. What a
plonker.
Regards Robert