Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Sounds in Macro
I have a macro to format a Excel 2007 spreadsheet. I have turned off Feedback
sounds in the options panel and in the macro: Application.EnableSound = False Application.DisplayAlerts = False Application.ScreenUpdating = False Application.Calculation = xlCalculationManual When I run the macro, I still get a stack of clicks (the clicks may be partial beeps) and beeps that take awhile to flush from the queue. The sounds realy slow down the macro when I don't need the sounds; the spreadsheet is small (480 rows by 3 columns), each cell is formatted for font color, style, size; cell color and border; and row outline. Each of these changes causes a feedback sounds. Is there a bug in Excel VBA? Does anyone else have this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sounds | Excel Discussion (Misc queries) | |||
msgbox sounds | Excel Programming | |||
Excel Sounds | Excel Discussion (Misc queries) | |||
sounds in Excel | Excel Discussion (Misc queries) | |||
Sounds in Excel | Excel Programming |