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