LinkBack URL
About LinkBacks
heres a little known trick in excel 2007>
options/customise/all commands
scroll down and add speak cells to your quick access toolbar
now select a range of populated cells and click the speak cell icon
heres a little known trick in excel 2007>
options/customise/all commands
scroll down and add speak cells to your quick access toolbar
now select a range of populated cells and click the speak cell icon
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Now that's cool! Anyway to choose a different speaking voice? The default appears to be a midrange female voice.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
hmm mine is a man
more here
http://support.microsoft.com/kb/306902 for xp
In the Voice selection box, click the voice that you want to use.On the Start menu, point to Settings, and then click Control Panel.
Double-click the Speech icon.
Click the Text To Speech tab.
NOTE: The available voices depend on your default language installation and any language packs that you may have installed.
Click OK. but i only have Microsoft Sam to choose from
in win 7 its
Choose Start→Control Panel→Ease of Access→Text to Speech.
apparently this is also available pre excel 2007 as well eg for excel 2002
Enable Text-to-Speech
To turn on the Text-to-Speech (TTS) feature in Microsoft Excel, do one of the following:
On the View menu, point to Toolbars, and then click to select Text To Speech.
-or-
On the Tools menu, point to Speech, and then click to select Show Text To Speech Toolbar.
Last edited by martindwilson; 07-12-2012 at 07:57 PM.
That's a pretty cool thang going on there! I don't know how practical this option is for most users but it is a fun toy to play with. I gave a like on this one.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
And automate it
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You can always use along with a userform to give periodic messages of progress so you don't have to look at the screen to see how far your code has progressed.
Or be some sort of trigger... etc.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
I saw this trick a few years back being used as an April Fools joke on co-workers.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
didn't say it was new .most people don't either know it exists,or if they do they don't know where to find it in excel 2007!
I actually have used that tool for a few years now when comparing printed documents (that have revisions) with the original electronic versions. Very handy tool so you can avoid looking back and forth between the screen and paper (or between two screens if comparing to a scanned image).
blimey...i am not entering this as a realistic tip.. it's just to prove how pointless this whole exercise is! i can think of loads of obscure stuff. but my mirror trick is the least well known!
http://www.excelforum.com/july-compe...53-mirror.html
Too late. I'm having this tip bronzed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks