Setting the language for all text in PowerPoint

As a native English speaker in Belgium I often get asked to proof-read text. I usually ask people to run a spell-checker first.

PowerPoint does not seem to have a simple way to select all text and then set the language. Frequently I get a .ppt files with basic spelling errors in the text boxes as they are set to Dutch spelling.

Here’s a recipe for setting the language for an entire PowerPoint presentation:

  • In PowerPoint select Tools / Macro / Visual Basic Editor. The editor window will pop-up
  • Select Insert / Module and a blank document will appear
  • Paste the following Visual Basic Macro into the blank document:
Sub SetLanguageInAllFrames()
For s = 1 To ActivePresentation.Slides.Count
For f = 1 To ActivePresentation.Slides(s).Shapes.Count
If ActivePresentation.Slides(s).Shapes(f).HasTextFrame Then
ActivePresentation.Slides(s).Shapes(f).TextFrame.TextRange _
.LanguageID = msoLanguageIDEnglishUS
End If
Next f
Next s
End Sub
  • Close the Visual Basic Editor and return to your presentation
  • Select Tools / Macro / Run Macros …
  • Run the macro SetLanguageInAllFrames

Now all of your text will be marked as US English and you can use the normal spell checker.

(You may need to enable macros before you can run it – leave a comment f you have problems. The VB code is based on this example from antonin_1955)

This entry was posted on Friday, December 9th, 2005 at 10:39 am and is filed under MSoffice. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

9 Responses to “Setting the language for all text in PowerPoint”

  1. Will says:
    December 9, 2005 at 11:11 am

    You don’t have to use US English of course. You can replace msoLanguageIDEnglishUS with any other valid language ID. Thanks Simon!

    Reply
  2. David Boschmans' Weblog says:
    December 10, 2005 at 3:16 pm

    Dinner with Scoble: debrief

    Thursday night we had the Brussels Geek Dinner. I enjoyed it very much, not only because of the presence…

    Reply
  3. Mike Reys says:
    December 12, 2005 at 11:13 pm

    This is exactly what I needed, I’ll distribute this article througout the office…

    Reply
  4. Dirk van Gorkum says:
    February 7, 2006 at 7:15 pm

    It did not work on all textboxes.
    I found anothet macro that seems to work better:
    http://answers.google.com/answers/threadview?id=199928

    Reply
  5. Will Moffat says:
    February 7, 2006 at 7:20 pm

    Thanks for the pointer Dirk. That does seem like a good solution. Maybe one day I’ll package it all together and make an add-on for Office.

    Reply
  6. Francis says:
    June 7, 2006 at 3:37 pm

    Hi,
    How can it work with text in the Note zone?
    What is the shape’s type of a Note Rectangle?

    Reply
  7. Raphie Hayat says:
    February 24, 2010 at 12:04 pm

    Will, you are a KING!
    Thanks for this Macro, saved me a lot of trouble!

    Reply
  8. Richard says:
    February 25, 2010 at 4:50 pm

    Great!!!!!

    Reply
  9. Option Explicit says:
    March 7, 2010 at 9:47 pm

    If you get

    “Compile error:
    Variable not defined”

    This means you have “Option Explicit” in the Module and this requires all variables to be declared.

    Just add:

    “Dim s, f As Integer”

    before the

    “For s = 1 To …” code

    Reply

Leave a Reply