View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default MsgBox sounds

If there's no other solution you could replace the messagebox with a custom
form.

Tim

"Rich" wrote in message
...
Thanks for the prompt response...however, this does not solve the problem.
The tickbox for "feedback with sound" was already un-checked...and even
with
these commands in the coding, the MsgBox still makes an annoying sound!
(I guess I should have mentioned this was turned off in my original post)

Any more clues or ideas?

"JLGWhiz" wrote:

To disable:

Application.EnableSound = False

To enable:


Application.EnableSound = True



"Rich" wrote in message
...
Hi,

I am using a MsgBox command in a program which is being distributed to
a
large number of people across the business. I usually have my sound
muted
so
did not notice anything...but since sending out have received
complaints
that
the MsgBox's make loads of noise.

Using simple code in Excel 2003:

MsgBox MsgBoxText, 64, MsgBoxTitle

Can anyone please tell me how I can disable the sounds...and then
re-enable
them once the text box has been displayed.

Thanks,

Rich