peacenik
03-18-2007, 11:26 PM
I am using the Worksheet Change event to control behaviour in the sheet, but I don't want changes done via a macro to use these rules. Is there some way to exclude changes done within a macro from this code. Here is some sample code.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Interior.ColorIndex <> 0 Then Target.Interior.ColorIndex = 0
End Sub
Thanks for taking the trouble to read this.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Interior.ColorIndex <> 0 Then Target.Interior.ColorIndex = 0
End Sub
Thanks for taking the trouble to read this.