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
Trying to run excel vba code when cell value changes from empty to entered value. 1
Deleting specific information 3
Data Val MultiSelect ? 1
Multiple entries from a drop down list 1
SelectionChange code will ONLY work if cell is Selected AGAIN. Need to work once cell in no longer s 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Change_Event troubles, no error & no work. 6

Top