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,

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,

A MsgBox with the Question button is quiet...
MsgBox "Did you check Cell B1 ?", vbQuestion
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"JMay"
wrote in message
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,

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

It beeped for me (and my dog like hearing!)

Jim Cone wrote:

A MsgBox with the Question button is quiet...
MsgBox "Did you check Cell B1 ?", vbQuestion
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"JMay"
wrote in message
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

Dave,
They all beep except for the one with the question icon.
I have the hearing ability of a doorknob. <g
Jim Cone
San Francisco, USA

Sub TestMe()
MsgBox "huh", vbInformation
MsgBox "huh", vbExclamation
MsgBox "huh", vbQuestion
MsgBox "huh", vbCritical
MsgBox "huh", vbYesNo
MsgBox "huh", vbAbortRetryIgnore
MsgBox "huh", vbRetryCancel
MsgBox "huh", vbOKCancel
End Sub


"Dave Peterson"
wrote in message
It beeped for me (and my dog like hearing!)


Jim Cone wrote:

A MsgBox with the Question button is quiet...
MsgBox "Did you check Cell B1 ?", vbQuestion
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"JMay"
wrote in message
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

Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)

But I like the sound <vbg.

I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.


Jim Cone wrote:

Dave,
They all beep except for the one with the question icon.
I have the hearing ability of a doorknob. <g
Jim Cone
San Francisco, USA

Sub TestMe()
MsgBox "huh", vbInformation
MsgBox "huh", vbExclamation
MsgBox "huh", vbQuestion
MsgBox "huh", vbCritical
MsgBox "huh", vbYesNo
MsgBox "huh", vbAbortRetryIgnore
MsgBox "huh", vbRetryCancel
MsgBox "huh", vbOKCancel
End Sub

"Dave Peterson"
wrote in message
It beeped for me (and my dog like hearing!)

Jim Cone wrote:

A MsgBox with the Question button is quiet...
MsgBox "Did you check Cell B1 ?", vbQuestion
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"JMay"
wrote in message
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

--

Dave Peterson

Dave,
I had already checked in the Sounds and Audio Devices list and
could not find anything relating to a "question" sound.
After reading your message, I checked again and it was there with
"none" applied to it. I believe it is the same person that hides my
car keys that is responsible. <g
Jim Cone


"Dave Peterson"
wrote in message
Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)
But I like the sound <vbg.
I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.

Thanks guys -- The ,vbQuestion add looks good
Jim May

"Jim Cone" wrote in message
:

Dave,
I had already checked in the Sounds and Audio Devices list and
could not find anything relating to a "question" sound.
After reading your message, I checked again and it was there with
"none" applied to it. I believe it is the same person that hides my
car keys that is responsible. <g
Jim Cone


"Dave Peterson"
wrote in message
Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)
But I like the sound <vbg.
I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.

I know about that person!



Jim Cone wrote:

Dave,
I had already checked in the Sounds and Audio Devices list and
could not find anything relating to a "question" sound.
After reading your message, I checked again and it was there with
"none" applied to it. I believe it is the same person that hides my
car keys that is responsible. <g
Jim Cone

"Dave Peterson"
wrote in message
Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)
But I like the sound <vbg.
I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.

--

Dave Peterson