I said Schrodinger's, not Schroeder's, Ernst not Steve ;-)


"Steve Schroeder" wrote in message
...
Don't make me hurt ya now :-P

"Bob Phillips" wrote in message
...
Schrodinger's spreadsheet? What sort of animal is that?

Bob


"Steve Schroeder" wrote in message
...
If a worksheet beeps, but no one is around to hear it, does it still
make
a
sound?

"Carlton Patterson" wrote in message
...
Hi all,

I don't know if I should be posting on Google groups or here, so
forgive
me if I'm not following protocol.

Anyway, can someone show me how to add/play a sound to the
following:

Private Sub Worksheet_Calculate()
If Range("I1").Value 0 Then
Beep
'or msgbox
'or play sound
'or send email
'or whatever
End If
End Sub

You'll notice that there is a "Beep" in the program but it doesn't
work.


Cheers

Carlton

*** Sent via Developersdex http://www.developersdex.com ***