+ Reply to Thread
Results 1 to 8 of 8

Thread: Text to speech annoyance

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    4

    Text to speech annoyance

    Perhaps someone knows how to stop this. Every time I open a spreadsheet (new or existing) and type in a cell, a window pops up that says:

    Text to speech
    This feature is not available. To make this feature available, please run Setup again, select "Add or Remove Features" and change the feature to "Run from My Computer" or "Run from CD/network."

    I don't want text to speech. I just want this block to stop popping up. I don't have the Office CD as it was installed from our network (multi-user license - we never actually had the CD at this location).

    Is there a way to do this?
    Last edited by poodle78; 11-10-2011 at 09:30 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Text to speech annoyance

    If you open the VBEditor (Alt+f11) then the Immediate Window (Ctrl+G) and enter this code, then press Enter:
    application.Speech.SpeakCellOnEnter = false
    what happens? Error?

  3. #3
    Registered User
    Join Date
    03-10-2010
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Text to speech annoyance

    Quote Originally Posted by romperstomper View Post
    If you open the VBEditor (Alt+f11) then the Immediate Window (Ctrl+G) and enter this code, then press Enter:
    application.Speech.SpeakCellOnEnter = false
    what happens? Error?
    Yes, error.

    Run-time error '1004':
    Application-defined or object-defined error

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Text to speech annoyance

    Interesting: what if you type:
    msgbox application.Speech.SpeakCellOnEnter
    does it say True or False?

  5. #5
    Registered User
    Join Date
    03-10-2010
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Text to speech annoyance

    Quote Originally Posted by romperstomper View Post
    Interesting: what if you type:
    msgbox application.Speech.SpeakCellOnEnter
    does it say True or False?
    It says True

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Text to speech annoyance

    Sounds like a registry problem then. If you have access rights to change it, you can open the registry editor (Start-Run, then type 'regedit' without the quotes and press Enter.) navigate to:
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
    and look for an entry in the right hand pane called SpeakOnEnter. Either delete it or set it to 0.

  7. #7
    Registered User
    Join Date
    03-10-2010
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Text to speech annoyance

    Quote Originally Posted by romperstomper View Post
    Sounds like a registry problem then. If you have access rights to change it, you can open the registry editor (Start-Run, then type 'regedit' without the quotes and press Enter.) navigate to:
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
    and look for an entry in the right hand pane called SpeakOnEnter. Either delete it or set it to 0.
    Set it to 0 and now no more annoyance. Thanks!!

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Text to speech annoyance

    Glad to help.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0