the change event fires when a cell is manually edited, changed by code, or
updated through a DDE formula or similar.

Whatever causes the A1 and B1 to updated must be making a change (that
triggers the change event) to a precedent cell of the watched range. For
example, if the watched cells have formulas that refer to cells A1 and/or B1
and you change them (A1 or B1), then that would trigger your beep.

I don't know what is causing A1 and B1 to change, so I can't say what you
need to do.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
The below code

'-------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
On Error Resume Next
For Each c In Range("D2:G5")
If Not Application.Intersect(Target, c.Precedents) Is Nothing Then
Interaction.Beep
End If
Next c
On Error GoTo 0
End Sub
'----------------------


sound on each minute change of my system clock. You see, cells
A1 and B1 displays the system clock hour and minute values. And the
watching
cells (Range D2:G5) look to the values displayed in A1 and
B1. Then the main macro is executed in minute intervals to let A1 and
B1 refresh their displays. Now although no "display" change is valid in
the
watched cells the sound alarm beeps in minute intervals too. Maybe my
other
suggestion may prevent that. I hope I didn't confuse you...
Hope we can solve this problem.
Regards
J_J