Intelligent Title Case

This is just what I was looking for! Thanks so much!

Thanks for the macro Allen.
As a seasoned proofreader and editor, I am constantly altering other peoples work with their constant use of capitalisation of every word when it comes to titles of books, and movies etc.
Using the 'Change Case' icon in WORD 365 is rather tedious and you don't always get the result you want. However, I now have placed your macro (with additional short words) in an icon and placed it on my work ribbon. Soooooo easy peasy now!

Surely there is another way to do this besides macros. My place of business' global security protocols have blocked the use of macros in all Microsoft suite applications.

Just using Shift + F3 to cycle between initial caps, all caps and no caps to change the case of selected text is still the most straightforward short cut of all.

From the comments, it's clear that "title casing" is not such a simple think, although most users use it not worring so much, which is not a happy new.
I found the tip looking for a different missing feature of the standard Title Case command. In romanic languages title casing is not the rule, but Sentence case is preferred. In this language, as not in English, the use of apostrophe can be frequent (and not always at the end of words, like "Jim's"), and Title Casing is increasingly used.
When you have apostrophe at the begining of the sentence, you need "L'Endemà del Big Bang" (first letter after the apostrophe in upper case).
When the apostrophe is in any other position (but before an entire word) you will want "Cercant l'Arca Perduda" (particle in lower case, the word beyond the apostrophe with the first character in upper case.
If someone founds that of any interest... I have no skills in writting VBA code... yet.

Further to my previous comment...

I used the macro in a table, selecting multiple cells (sentences), which caused the isse (OK, I'm a NOOB!)

Is there any way to change the macro so I can use it on multiple sentences?

Thanks!!

This has worked for me for a long time, and now it stopped working - ALL words are now capitalized. Grrr!!! What is wrong?Sub TitleCase() Dim lclist As String Dim wrd As Integer Dim sTest As String ' list of lowercase words, surrounded by spaces lclist = " of the by to this is from a then or for as and when if any on an in at " Selection.Range.Case = wdTitleWord For wrd = 2 To Selection.Range.Words.Count sTest = Trim(Selection.Range.Words(wrd)) sTest = " " & LCase(sTest) & " " If InStr(lclist, sTest) Then Selection.Range.Words(wrd).Case = wdLowerCase End If Next wrdEnd Sub

Haha, Rod Grealish! Yes, I guess you're right. If "turn on" means "to become disloyal," as in "Disgusted with the team, Joe turned on them and never attended another game," then "on" should be lowercase, as it's a preposition.

The macro above will only work for one sentence of course. You normally wouldn't require Title Case for more than that, but just be aware that if additional sentences are selected this macro will cause each of them to begin with a lower-case letter if the sentence starts with one of the words in the LcList (The, This, From, By, etc).

Presumably there is a semantic difference between "Turn On Your Audience with Music" and "Turn on Your Audience with Music" . :-)

Great! Thanks for the terrific, time-saving tip! To follow up on Patritica Compton's comment, all the publishers I work for (some major publishers and some Ivy League university presses) want verbs capitalized in titles. Thus, "Is," "Are," "Were," etc. , are capped, even though they are short words. Other readers might want to note this guideline. Additionally, and now I'm showing my true nerdiness, words like "on," and "up" are not always prepositions and, at least for my publishers, are capped: "Turn On Your Audience with Music." Finally, most titles capitalize the first and last word of titles, no matter what the part of speech: "On Being a Beatles Fan," "What Is the Earth's Crust Made Of?"
So your fantastic macro can be used anyway, and the user needs just to quickly skim the title afterward to make sure none of the exceptions cited above exist.
Thanks again!

I believe it is a misunderstanding to say that common rules of capitalization require "short" words to be lower-cased. The rule used to be that articles (a, an, the) and prepositions (sometimes all, or sometimes only those 5 letters or fewer long, depending upon the editor) were not capitalized unless at the beginning of the title. "Is" is a verb, and verbs get capitalized no matter how short they are. I do realize that the "common rules" may have changed since many people are no longer sufficiently educated in grammar to understand what part of speech a particular word represents.