MsgBox sounds

[Rich]

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

 

[JLGWhiz]

To disable:

Application.EnableSound = False

To enable:


Application.EnableSound = True

 

[Rich]

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?

 

[Peter T]

The sounds are defined in system settings (control panel, sounds). It's
possible to programmatically change these but generally regarded as very bad
practice to so (although in this case I sympathise with the objective!).

Regards,
Peter T

 

[Tim Williams]

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

Tim