khalid79m
11-15-2009, 02:12 PM
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
'Page 3
If ActiveCell.Address = ThisWorkbook.Sheets("Intervention_3.0").Range("C95").Address Then
Run "Int3_Update_Page3"
Exit Sub
End If
If ActiveCell.Address = ThisWorkbook.Sheets("Intervention_3.0").Range
("H95").Address Then
Range("M95:N95").ClearContents
Exit Sub
End If
If ActiveCell.Address = ThisWorkbook.Sheets("Intervention_3.0").Range("M95").Address Then
Run "Int3_Update_Page3"
Exit Sub
End If
Application.ScreenUpdating = True
End Sub
this above runs the Int3 Update Page3 if C95 or M95 changes, if H95 changes then M95:N95's contents are clearer. Only one problem on h95 changeing the contents of m95:n95 are cleared but since m95 has changed it runs the update. Can I stop it from doing that
Application.ScreenUpdating = False
'Page 3
If ActiveCell.Address = ThisWorkbook.Sheets("Intervention_3.0").Range("C95").Address Then
Run "Int3_Update_Page3"
Exit Sub
End If
If ActiveCell.Address = ThisWorkbook.Sheets("Intervention_3.0").Range
("H95").Address Then
Range("M95:N95").ClearContents
Exit Sub
End If
If ActiveCell.Address = ThisWorkbook.Sheets("Intervention_3.0").Range("M95").Address Then
Run "Int3_Update_Page3"
Exit Sub
End If
Application.ScreenUpdating = True
End Sub
this above runs the Int3 Update Page3 if C95 or M95 changes, if H95 changes then M95:N95's contents are clearer. Only one problem on h95 changeing the contents of m95:n95 are cleared but since m95 has changed it runs the update. Can I stop it from doing that