Forum Discussion

Roberto1968's avatar
Roberto1968
Copper Contributor
Sep 24, 2021

need to stop text to speech in excel

I am using Excel spreadsheets for my remote job.  Suddenly the narrator begins after every typed made in the spreadsheet.  Annoying.  I have tried all sorts of things and it wont stop.  
excel
Leland_Parker's avatar
Leland_Parker
Copper Contributor
Jan 03, 2022

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.

  • johnfurnes's avatar
    johnfurnes
    Copper Contributor
    Feb 11, 2022

    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.

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Feb 11, 2022

      johnfurnes 

      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.

      • bilguna's avatar
        bilguna
        Copper Contributor
        Nov 21, 2022

        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 

Resources