2007 wont run 2003 coded sheet_change event.

G

Grid

Have saved book in full macro mode (.xlsm) but the sheet_change event will
only run once and then nothing.Using data validation and comparing the value
of target cell and then offsetting. Have remmed all in the event to only
leave 1 range to no avail. Very confusing that the code will only run for the
first sheet change andthen nothing until it is closed and re-opened.
Some code below.

If Not Intersect(Target, Range("D8:M38")) Is Nothing Then
If Target.Offset(0, -1).Value = Range("P28") Then
If Target.Value <> 0 Then
If Target.Value < Range("Q28").Value Then
MsgBox Range("P28") & " cannot work before " &
Range("Q28")
End If
End If
End If
End If

Ideas?
 
B

Barb Reinhardt

Is it possible that you have

Application.EnableEvents = FALSE

somewhere in your code? If so, you've turned off events and they won't be
triggered again until you allow events to be triggered with

Application.EnableEvents = TRUE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Junp start my Select Case Macro 12
Deleting specific information 1
capture date at another sheets using Marlett 1
input info when pasted in cells 5
Change_Event troubles, no error & no work. 6
Pass condition formatting across worksheets via vba. 0
Double click fails to run the code, just selects the cell 12
If cancel list box don't enter FALSE in list 2

Top