Norm,
:You may want to check your system clock unless xmas is already passed for
you.

--
Don Guillett
SalesAid Software

"Norman Jones" wrote in message
...
Hi Emea,

If the Sounds macro is in a standard module in the workbook,

Right-click the worksheet tab, select View Code and paste the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("A1"), Target) Is Nothing Then
If Range("A1").Value Range("A2").Value Then
Sounds
End If
End If
End Sub

---
Regards,
Norman


"Emea training " wrote in
message ...
How can I run a macro called "sounds", when a value within a spreadsheet
ie: cell A1 goes over a pre-defined value, located in another cell (say
a2)?

I have tried but am failing!


---
Message posted from http://www.ExcelForum.com/