Forum Discussion

Business_Sheardie's avatar
Business_Sheardie
Copper Contributor
Apr 14, 2022

Speak Cells

I turned on Speak Cells in Microsoft Excel but now I cannot remove. I removed the command from the toolbar. Any ideas?
excel
HansVogelaar's avatar
HansVogelaar
MVP
Apr 14, 2022

Business_Sheardie 

Press Alt+F11 to activate the Visual Basic Editor.

Press Ctrl+G to activate the Immediate window.

Type or copy/paste the line

Application.Speech.SpeakCellOnEnter = False

With the insertion point anywhere in that line, press Enter.

Switch back to Excel.

Did that solve the problem?

Mark_S_122's avatar
Mark_S_122
Copper Contributor
Apr 27, 2022
I had the same problem. I tried your suggestion. it now toggles, but instead of speaking on enter, it will only read out loud the series of cells I highligbhted
    • Business_Sheardie's avatar
      Business_Sheardie
      Copper Contributor
      May 05, 2022

      HansVogelaar @Mark_S_122 

       

      Hi all, thanks for helping out here. I found a solution (or my IT bods did at work). There is a command called Speak Cells On Enter. The problem is I couldn't find this in All Commands. So when in Excel I simply used the Search Box on the Excel Bar above the Menu bar and typed in Speak Cells on Enter. I then right clicked on this to add to toolbar. You need to use this to toggle on and off.