I still got the beep. But the sounds that came with this download were stopped:


http://www.microsoft.com/downloads/d...n&Hash=N4HGGN8
or
http://snipurl.com/ucyf

(I figured that since I like the sounds, I should share the link!)

===
To the OP:
One of my coworkers used to snip the wires to the pc's internal speakers. That
may not be an option for everyone, though <vbg.

Gord Dibben wrote:

Private Sub Worksheet_Activate()
Application.EnableSound = False
MsgBox "Check Cell B1 - For Correct Month #"
End Sub

This is the only way I know of turning off a msgbox beep.

Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 14:06:00 -0800, JMay wrote:

I just entered into one of my spreadsheet modules:

Private Sub Worksheet_Activate()
MsgBox "Check Cell B1 - For Correct Month #"
End Sub

Now as I activate the (same) sheet I get (at no additional charge)
this "BEEP" << How can I disable this annoying sound?

TIA,



--

Dave Peterson