Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you stop a Msgbox from making a beep sound? Thanks.
hi, I haven't experienced a beeping message box. When does the beep occur, is it: - when the message box is displayed? - or when the user presses a button on the message box? Can you view the macro code? Is the Msgbox line preceeded by a code line stating "Beep"? If so, delete the "Beep" statement. hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111964 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you stop a Msgbox from making a beep sound? Thanks.
If I recall, the beep is setup in your system sounds (asterisk). You can turn the sound off if you want. Hope that helps, "broro183" wrote in message ... hi, I haven't experienced a beeping message box. When does the beep occur, is it: - when the message box is displayed? - or when the user presses a button on the message box? Can you view the macro code? Is the Msgbox line preceeded by a code line stating "Beep"? If so, delete the "Beep" statement. hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111964 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you stop a Msgbox from making a beep sound? Thanks.
try: Application.EnableSound = False Just make sure to turn the property back to true after code execution, as this turns off sound feedback for ALL Office applications. -- Burnnie Holliday -- Burnnie Holliday Data Wrangler |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add sound ( beep ) if cell content changes in live data | Excel Discussion (Misc queries) | |||
Sound / Beep function from within VB or Excel VBA | Excel Programming | |||
Beep Change The Sound | Excel Discussion (Misc queries) | |||
Beep or Make Sound after Calcing | Excel Programming | |||
How BEEP on internal speakers, not on sound-card? | Excel Programming |