Worksheet_Change Event does not execute upon change of cell

This code is odd--why would you assign five different values to the same cell? Only that last one matters.

What module is this code in? Is it the same sheet that you want to detect changes in? If it is not, that's your problem. If it is, then put in a breakpoint or a MsgBox call to see if it is entering the code. Better yet, attach your file here.

Private Sub Worksheet_Change(ByVal Target As Range)

MsgBox "Change detected in cell " & Target.Address

If Target.Address <> "$E$9" Then Exit Sub

Application.ScreenUpdating = False
Application.EnableEvents = False

Worksheet("PPW").Range("E9") = A
Worksheet("PPW").Range("E9") = B
Worksheet("PPW").Range("E9") = C
Worksheet("PPW").Range("E9") = D
Worksheet("PPW").Range("E9") = E

Call Update_PPW_GPMPct

Call Filter_Details

Application.ScreenUpdating = True
Application.EnableEvents = True

End Sub

I didn't catch this the first time around. The correct code is:

Worksheets("PPW").Range("E9") = A

You might try zipping the file and see if that's under the limit. Limits can be found in the "?" link when you click on the paper clip to attach a file:

Filetype	Max File-size	Max Width	Max Height
bmp	100.0 KB	-	-
csv	1,000.0 KB	-	-
doc	1,000.0 KB	-	-
docm	1,000.0 KB	-	-
docx	1,000.0 KB	-	-
gif	100.0 KB	-	-
jpe	100.0 KB	-	-
jpeg	100.0 KB	-	-
jpg	100.0 KB	-	-
pdf	9.77 MB	-	-
png	100.0 KB	-	-
txt	100.0 KB	-	-
xls	1,000.0 KB	-	-
xlsb	9.77 MB	-	-
xlsm	1,000.0 KB	-	-
xlsx	1,000.0 KB	-	-
zip	9.77 MB	-	-