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,