Speak Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-3285954%22%20slang%3D%22en-US%22%3ESpeak%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3285954%22%20slang%3D%22en-US%22%3E%3CP%3EI%20turned%20on%20Speak%20Cells%20in%20Microsoft%20Excel%20but%20now%20I%20cannot%20remove.%20I%20removed%20the%20command%20from%20the%20toolbar.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3285954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3297492%22%20slang%3D%22en-US%22%3ERe%3A%20Speak%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3297492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1372711%22%20target%3D%22_blank%22%3E%40Mark_S_122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20afraid%20I%20cannot%20reproduce%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3297268%22%20slang%3D%22en-US%22%3ERe%3A%20Speak%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3297268%22%20slang%3D%22en-US%22%3EI%20had%20the%20same%20problem.%20I%20tried%20your%20suggestion.%20it%20now%20toggles%2C%20but%20instead%20of%20speaking%20on%20enter%2C%20it%20will%20only%20read%20out%20loud%20the%20series%20of%20cells%20I%20highligbhted%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286177%22%20slang%3D%22en-US%22%3ERe%3A%20Speak%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1357956%22%20target%3D%22_blank%22%3E%40Business_Sheardie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPress%20Alt%2BF11%20to%20activate%20the%20Visual%20Basic%20Editor.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2BG%20to%20activate%20the%20Immediate%20window.%3C%2FP%3E%0A%3CP%3EType%20or%20copy%2Fpaste%20the%20line%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3EApplication.Speech.SpeakCellOnEnter%20%3D%20False%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EWith%20the%20insertion%20point%20anywhere%20in%20that%20line%2C%20press%20Enter.%3C%2FP%3E%0A%3CP%3ESwitch%20back%20to%20Excel.%3C%2FP%3E%0A%3CP%3EDid%20that%20solve%20the%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3322009%22%20slang%3D%22en-US%22%3ERe%3A%20Speak%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1372711%22%20target%3D%22_blank%22%3E%40Mark_S_122%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Speak%20cells%20on%20Enter.PNG%22%20style%3D%22width%3A%20578px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369423iC0536B749E26FCF7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Speak%20cells%20on%20Enter.PNG%22%20alt%3D%22Speak%20cells%20on%20Enter.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20all%2C%20thanks%20for%20helping%20out%20here.%20I%20found%20a%20solution%20(or%20my%20IT%20bods%20did%20at%20work).%20There%20is%20a%20command%20called%20Speak%20Cells%20On%20Enter.%20The%20problem%20is%20I%20couldn't%20find%20this%20in%20All%20Commands.%20So%20when%20in%20Excel%20I%20simply%20used%20the%20Search%20Box%20on%20the%20Excel%20Bar%20above%20the%20Menu%20bar%20and%20typed%20in%20Speak%20Cells%20on%20Enter.%20I%20then%20right%20clicked%20on%20this%20to%20add%20to%20toolbar.%20You%20need%20to%20use%20this%20to%20toggle%20on%20and%20off.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3322070%22%20slang%3D%22en-US%22%3ERe%3A%20Speak%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1357956%22%20target%3D%22_blank%22%3E%40Business_Sheardie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClever%20solution.%20Thanks%20for%20sharing!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I turned on Speak Cells in Microsoft Excel but now I cannot remove. I removed the command from the toolbar. Any ideas?

5 Replies

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

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

@Mark_S_122 

I'm afraid I cannot reproduce that.

@Hans Vogelaar @Mark_S_122 Speak cells on Enter.PNG

 

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.

@Business_Sheardie 

Clever solution. Thanks for sharing!