Forum Discussion
need to stop text to speech in excel
It sounds like someone has turned on the "Speak Cells on Enter" option.
This is the https://answers.microsoft.com/en-us/msoffice/forum/all/text-to-speech-in-excel/7d899687-6b59-4dc9-8b18-b10bbd720cf4 about how to turn it off.
https://excelribbon.tips.net/T007927_Turning_Off_Speech_Capabilities.html also gives the procedure for turning it off.
The given solution does not work for Excel 2022. My solution is to disable all sound, which does not work very well either. I hope someone understands how this works, and can help.
You can do the following:
- Press Alt+F11 to activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type or copy/paste the following line into the Immediate window:
Application.Speech.SpeakCellOnEnter = False
- With the insertion point anywhere in that line, press Enter.
- Close the Visual Basic Editor.
Speak on Enter should now be disabled.
This is really working, I have searched more than 1 week. I believe there is a bug, we can not find that command in the ribbon customization part; Thanks a lot million times, HansVogelaar
- Thank you so much, finally I disable this function, too 🙂
HansVogelaar I tried this and get the yellow triangle w ! and the message 'This formula is missing a range refernce or a defined name'
The 'Go to' box is blank; I entered 'Application.Speech.SpeakCellOnEnter = False' in 'Reference'.
Is that correct?
Please read the instructions again. You need to activate the Visual Basic Editor first, then press Ctrl+G there.
