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.  

7 Replies

  • Leland_Parker's avatar
    Leland_Parker
    Copper Contributor

    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

      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

        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.

Resources