ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Turn Off Sounds in Macro (https://www.excelbanter.com/excel-programming/392591-turn-off-sounds-macro.html)

Pause

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?



All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com