a·gen·tic a·gil·i·ty

I spell it as Favourite and you as Favorite

TL;DR; Explains the differences between British and American English spelling, and shows how to switch language settings in Word and PowerPoint using macros for correct spellcheck.

Published on
3 minute read
Image
https://nkdagility.com/resources/nIpxDPFtjBE
Subscribe

On of the issues that we have had in the office recently is that the rest of the Office, through no fault of their own, speaks and uses American English. I however along with the majority of the English speaking world use British English.

Microsoft have recognised this with the inclusion of Windows 8 (English-United Kingdom) as an edition of Windows that you can install.

I spell it as Favourite and you as Favorite

Figure: Windows 8 (English-United Kingdom)

This will then give us the holly grail of Favourite spelled correctly in Windows!

Using the obvious truth of Wikipedia I make it around 2,121,502,169 people live in countries that have English as their national language and only 309,442,00 of which are American English… give or take…

I spell it as Favourite and you as Favorite

Figure: Who speaks what where

Yes, I realise that I am being wholly unscientific and that I currently live smack in that red area, but I just can’t bear to go native where language is concerned. Every time I see an incorrect spelling of “Tire”, “Favourite” or “Serialise” I have and insatiable itch to fix it…

Macros to the rescue

Word is easy.. if you want to change the default language all you do is Ctrl+A to select all of the text and change it.

I spell it as Favourite and you as Favorite

Figure: Changing document language

Similarly the reverse is true and you can have your bad spelling I spell it as Favourite and you as Favorite

PowerPoint is a little more difficult. You need to change it for every shape and there is no way to globally change this. Which does kind of suck, but not is you know macros. So fire up your “Developer” bar, select “Add Code” and create a new module.

I spell it as Favourite and you as Favorite

Figure: How to get the developer bar

To that module you can then add the following code.

 1Option Explicit
 2Public Sub ChangeSpellCheckingLanguageUK()
 3    Dim j As Integer, k As Integer, scount As Integer, fcount As Integer
 4    scount = ActivePresentation.Slides.Count
 5    For j = 1 To scount
 6        fcount = ActivePresentation.Slides(j).Shapes.Count
 7        For k = 1 To fcount
 8            If ActivePresentation.Slides(j).Shapes(k).HasTextFrame Then
 9                ActivePresentation.Slides(j).Shapes(k) _
10                .TextFrame.TextRange.LanguageID = msoLanguageIDEnglishUK
11            End If
12        Next k
13    Next j
14End Sub
15
16
17Public Sub ChangeSpellCheckingLanguageUS()
18    Dim j As Integer, k As Integer, scount As Integer, fcount As Integer
19    scount = ActivePresentation.Slides.Count
20    For j = 1 To scount
21        fcount = ActivePresentation.Slides(j).Shapes.Count
22        For k = 1 To fcount
23            If ActivePresentation.Slides(j).Shapes(k).HasTextFrame Then
24                ActivePresentation.Slides(j).Shapes(k) _
25                .TextFrame.TextRange.LanguageID = msoLanguageIDEnglishUS
26            End If
27        Next k
28    Next j
29End Sub

Figure: Macro to change between English US and English UK

Now at the click of a button you can change the whole presentation from “Bad English” to “Good English” and back again.

I spell it as Favourite and you as Favorite

Figure: Change PowerPoint language

This will help me greatly as I can then write all of my things in the English that I am accustomed to…

I spell it as Favourite and you as Favorite

Figure: My keyboard settings

What do you think are my chances at getting the world to switch to Gaelic?

Smart Classifications

Each classification [Concepts, Categories, & Tags] was assigned using AI-powered semantic analysis and scored across relevance, depth, and alignment. Final decisions? Still human. Always traceable. Hover to see how it applies.

Subscribe

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

New Signature Logo

New Signature

Lockheed Martin Logo

Lockheed Martin

Workday Logo

Workday

Kongsberg Maritime Logo

Kongsberg Maritime

Microsoft Logo

Microsoft

Cognizant Microsoft Business Group (MBG) Logo

Cognizant Microsoft Business Group (MBG)

Genus Breeding Ltd Logo

Genus Breeding Ltd

DFDS Logo

DFDS

Sage Logo

Sage

Epic Games Logo

Epic Games

Schlumberger Logo

Schlumberger

Lean SA Logo

Lean SA

Graham & Brown Logo

Graham & Brown

NIT A/S

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Boxit Document Solutions Logo

Boxit Document Solutions

Ericson Logo

Ericson

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Ghana Police Service Logo

Ghana Police Service

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Royal Air Force Logo

Royal Air Force

Washington Department of Transport Logo

Washington Department of Transport

Kongsberg Maritime Logo

Kongsberg Maritime

Alignment Healthcare Logo

Alignment Healthcare

Epic Games Logo

Epic Games

ProgramUtvikling Logo

ProgramUtvikling

Lean SA Logo

Lean SA

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)