stop macro from running on EVERY cell change!!
i am running the following macro,
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("FE11") = 1 Then
MsgBox "VEHICLE MAY BE DUE FOR A SERVICE !!", vbBEEP + vbOKOnly
the value in cell "FE11" is derived from a formula, which either returns a value of "1" or "0". if the value of cell "FE11"="1" i would like the macro to display a message and alarm sound at the same time alerting the user to take a different course of action.
i am a newbie to programming and can't figure out how to stop it from running everytime any cell value is changed in the worksheet other than "FE11" !
any help would be appreciated !!!
thanks in advance