John,
Thanks a bunch. I've been through the tips on JW's
site and only remember the generic sound tip.

Thanks for the redirect,

Mike

-----Original Message-----
Mike,

Take a look he
http://j-walk.com/ss/excel/tips/tip87.htm

John

"Mike" wrote in
message
...
Hello all,

I have an excel sheet that updates every 2 seconds from
an
SQL server that is fed by a PLC. I am monitoring the
speed
of a manufacturing line. I want a wave file to play if
the
line stops (cell value=0). I found the code for calling
sounds, but how do I get it to play once, after the cell
equals 0? I assume the code would be similar to play a
different sound when the line starts back up again?

Windows 2000
Excel 2000

Thanks,
Mike


.