Please help. I am using Excel 97. I have a list validation box that was put in manually so that the change event will occur and I can change locked/unlocked cells based on it. The problem is that I had to omit the change target so the code is running after every worksheet change. When I tried to use if target = range ("f10"), which is my list validation cell, it would not use the code when this cell value changed. I think it is not recognizing the selection of this cell as the target range. Does anyone know how to get around this problem?

This is a small portion of the code:
Private Sub Worksheet_change(ByVal target As Range)
Application.ScreenUpdating = False
If Range("J10").Value = Range("M26").Value Then
ActiveSheet.Unprotect
Range("J12,J16,J18,J19,J20,J22,J24,J26,J28").Activate
Selection.Locked = True
Range("J16,J18,J20,J22,J24,J26,J28").Select
Range("J16,J18,J20,J22,J24,J26,J28").Activate
Selection.Locked = False
Range("j20").Select
Selection.NumberFormat = "$#,##0.00"
Range("j22").Select
Selection.NumberFormat = "mm/dd/yyyy"
ActiveSheet.Protect UserInterfaceOnly:=True
ActiveSheet.EnableSelection = xlUnlockedCells
Range("j10").Select