Re: MsgBox sounds
- From: "Tim Williams" <timjwilliams@xxxxxxxxxxx>
- Date: Wed, 10 Jun 2009 19:42:45 -0700
If there's no other solution you could replace the messagebox with a custom
form.
Tim
"Rich" <Rich@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7951ACF0-966E-472D-9D6A-1B8088FF4C83@xxxxxxxxxxxxxxxx
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" <Rich@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4052083E-45AD-44E9-85FD-B4863355B0AA@xxxxxxxxxxxxxxxx
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
.
- References:
- MsgBox sounds
- From: Rich
- Re: MsgBox sounds
- From: JLGWhiz
- Re: MsgBox sounds
- From: Rich
- MsgBox sounds
- Prev by Date: Re: strange vba break
- Next by Date: Re: Excel automation: how to employ Find function?
- Previous by thread: Re: MsgBox sounds
- Next by thread: HPageBreaks and InsertRow Problem
- Index(es):
Relevant Pages
|