PDA

View Full Version : Solved: About Application.Speak



Erdin? E. Ka
09-23-2006, 05:51 AM
Hi everyone!
It's me again. :hi:

I wrote these codes as a joke next week. After i run the code Excel is speaking for all things that what i do in Excel. I can not stop this. :dunno
Can you help me about stoping the speak method of Excel until i write an another code which is includes speak method?

Thank you. : pray2:


Sub LetsSpeakTheWhoIsTheBetter()

Fenerbahce = 6
Galatasaray = 0

[A1] = "Fenerbahche is Better than All others"

Do

Range("A1").Speak

Loop Until Galatasaray >= Fenerbahce

'You can stop this by Ctrl & Pause Break: End :)
End Sub

mdmackillop
09-23-2006, 07:45 AM
You've forgotten to increment the Galatasaray variable

Do
Range("A1").Speak
Galatasaray = Galatasaray + 1
Loop Until Galatasaray >= Fenerbahce

Erdin? E. Ka
09-23-2006, 08:01 AM
I think i couldn't tell the problem. :dunno

I wrote the code as a joke.

The code like a cercular reference of formulas, i know. :whistle:

I know do-loop but, my problem not about the code, still my Excel Appication is speaking. I break the code last week. Since i stop the code, while i working in Excel, Excel is speaking my every input to spreadsheet.

For example, i am writing to A1 cell "Hi there" then Excel is speaking "Hi there" at the moment.

But i closed that code last week...

Can i tell it?

Please help me. :(

mdmackillop
09-23-2006, 08:10 AM
:rotflmao:

I'll see what I can find.

mdmackillop
09-23-2006, 08:21 AM
1. Where did you add this code?
2. Check if Narrator is turned on.
Programs/Accessories/Accessibility/Narrator

Erdin? E. Ka
09-23-2006, 09:01 AM
1. Where did you add this code?
2. Check if Narrator is turned on.
Programs/Accessories/Accessibility/Narrator

I wrote at Module2 of a saved Spreadsheet.

My Win. XP Pro is Turkish Edition.

Translation: English - Turkish...

Programs = Programlar : Ok.
Accessories = Donatılar : Ok.
Accessibility = Erişlebilirlik : Ok.
Narrator = What ? :dunno I couldn't found it.
You mean (Hizmet Programı Y?neticisi) Service Program Manager ?

I can not find "Narrator"... :think:

mdmackillop
09-23-2006, 09:06 AM
Narrator is used to read what is typed. You may not have it enabled (Windows option)

I'm not experiencing your problem with the code, thankfully. but I'll look further.

Erdin? E. Ka
09-23-2006, 09:12 AM
Narrator is used to read what is typed. You may not have it enabled (Windows option)

I'm not experiencing your problem with the code, thankfully. but I'll look further.

Narrotor should be in Turkish "Anlatıcı" or "Konuşmacı" or "Spiker" ect. But I can not found.

Anyway,

I want to thank you for all.

Best regards.:friends:

Erdin? E. Ka
09-23-2006, 08:58 PM
Hi everyone!:hi:

Thank Allah! Finally I found the correct solution to silence Excel application.:rotlaugh:

Here is the codes:


Sub ShutUpExcel()
Application.Speech.SpeakCellOnEnter = False
End Sub


Thanks a lot for all hepls. :friends: