Share via

No speak cell on enter Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20140)

Anonymous
2024-01-28T18:38:18+00:00

Hello, I wanted to add 'Speak cell on enter' to the access bar but I couldn't find it. Could you add this feature into this version of Excel please?
Is there a replacement of 'Speak cell on enter' I could use right now?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-01-28T19:29:19+00:00

    Option 1:

    Press Alt+F11 to activate the Visual Basic Editor.

    Press Ctrl+G to activate the Immediate window.

    Enter the following line (or copy/paste it), then press Enter:

    Application.Speech.SpeakCellOnEnter = True

    To turn it off, do the same but with False instead of True.

    Option 2:

    Create the following macro in your personal macro workbook PERSONAL.XLSB:

    Sub ToggleSpeechOnEnter()
    With Application.Speech
        .SpeakCellOnEnter = Not .SpeakCellOnEnter
    End With
End Sub

    Running the macro will toggle Speak Cells on enter on/off.

    Assign this macro to a Quick Access Toolbar button and/or a custom keyboard shortcut for each of use.

    See Excel Personal Macro Workbook | Save & Use Macros in All Workbooks if you're not familiar with the personal macro workbook.

    1 person found this answer helpful.
    0 comments