need to stop text to speech in excel

Copper Contributor

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

It sounds like someone has turned on the "Speak Cells on Enter" option.

This is the Microsoft post about how to turn it off.

This article 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.

@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.

@Hans Vogelaar 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?

 

 

 

@Steve805 

Please read the instructions again. You need to activate the Visual Basic Editor first, then press Ctrl+G there.

Thank you so much, finally I disable this function, too :)

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, @Hans Vogelaar