Forum Discussion

nourusoff's avatar
nourusoff
Copper Contributor
Sep 07, 2024

Turn off Excel voicing of data entered on worksheet

When I enter a formula

into my worksheet, Excel reads it back to me.  How do I turn off the text-to-voice?

 

  • nourusoff's avatar
    nourusoff
    Copper Contributor
    Nick Ourusoff again! It was not working for me, as I had thought, until just NOW! I feel stupid, spent more than 3 hours ....! At the outset: my version of Excel does not have Speak on Enter (on or off the ribbon); nor is there a version or date for my version of Excel anywhere on the menu (like an ABOUT Excel). I start with my Excel worksheet and the cursor somewhere in the worksheet. I hit Alt F11 and the top indicates I have Visual Basic Editor and there is a small Window with the a Menu and at the bottom on the left is a small pane labelled "Immediate" and a right pane labelled "Watches". I type "Application.Speech.SpeakCellOnEnter = False" in the Immediate window and press Enter,. And then - (what I didn;t do previously xx times!) I closed the Visual Basic Editor by activating File on the Vusya Basic Menu whose last option is Close and Return to Excel. (I don't think you mentioned that it was necessary to access the small window Menu for Visual Basic ) Whew! It is difficult to follow directions exactly ( as I know...! it keeps us humble) Thanks, (I think) I got it! But why no Speak on Enter command?
    • Hermes_Santos14's avatar
      Hermes_Santos14
      Copper Contributor

      Hi nourusoff 

       

      What you described makes perfect sense, and I'm glad you managed to solve it, even if it took some time.

      Regarding the "Speak on Enter" command not appearing in the menu or options in Excel, this might be because the feature is not enabled by default or it wasn’t included visibly in some versions of Excel. Some Excel functionalities may not be in the conventional ribbon and instead are accessed directly via VBA code or lesser-known commands, as in your case.

      Excel hides or reorganizes certain features in newer versions or depending on the settings you have installed. The way you disabled it using the Visual Basic Editor was a great alternative and worked well.

Resources