If EnableEvents if deactivated for some reason, it will not run. But to be on the safe side, I would start by putting a stop point at the first line of code, and confirming it truly does not trigger. Or add a messagebox to start... does it truly not trigger?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Selection.Count 'debugging test.
If Selection.Count = 1 Then
If Not Intersect(Target, Range("D4")) Is Nothing Then
Call MyMacro
End If
End If
End Sub
Also, this may seem like a dumb question, but the code IS in the correct sheet? I simply don't know how experienced you are... don't mean to be daft asking that. I've seen users put that in a standard module, which of course would not work.
Bookmarks