Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2018, 08:17 AM
florian388 florian388 is offline problems with language settings Mac OS X problems with language settings Office 2016 for Mac
Novice
problems with language settings
 
Join Date: Nov 2018
Posts: 1
florian388 is on a distinguished road
Post problems with language settings

Hello,
I'm having problems with the language settings of my 2016 Word version on Mac.
Even though I change my standard language settings to English in a document, the program keeps jumping back to German which is my PC's basic setting. Especially when I paste sth into my document, the part I inserted is marked as German even though I switched everything to english before.
When I change the standard language it keeps telling me that from now on all future new files will be in english, which isn't true because as soon as I open a new one everything is in German again.
Is there some way to change the language settings and I'm missing it?
Reply With Quote
  #2  
Old 11-24-2018, 06:18 PM
Charles Kenyon Charles Kenyon is offline problems with language settings Windows 10 problems with language settings Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The proofing language settings in Word are:
  • Not set application-wide
  • Not set by the document
  • Not even set by the paragraph
  • They are set by the character.
When you paste something into a Word document, unless pasted as plain text, it will carry its proofing language settings with it.


The proofing language can also be stored in styles.
Reply With Quote
  #3  
Old 11-24-2018, 06:22 PM
Charles Kenyon Charles Kenyon is offline problems with language settings Windows 10 problems with language settings Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Here is a macro that can be used in your Normal template to set styles.


Code:
Sub StyleSpanish()
'   Written 10 November 2018
'   Charles Kenyon
'   Intended to set all styles to Spanish, proofing, not automatitically update
'
    Dim aStyle As Style
    On Error Resume Next ' Some styles have no language attribute and will give an error
    For Each aStyle In ActiveDocument.Styles
'        aStyle.AutomaticallyUpdate = False ' probably do not want this for TOC styles - future work
        aStyle.LanguageID = wdSpanish
        ' For variations of English, see https://docs.microsoft.com/en-us/office/vba/api/word.wdlanguageid
        aStyle.NoProofing = False   ' also turn on spelling and grammar checking
    Next 'aStyle
    ActiveDocument.UpdateStylesOnOpen = False ' For information on using this line, see:
'       http://www.shaunakelly.com/word/sharing/willmyformatchange.html
    On Error GoTo 0
 End Sub




Here is a macro that can be used to make sure everything currently in a document has the correct proofing language.


Code:

Sub ProofingLanguageSpanishAllStory()    ' based on field updater by Greg Maxey
    ' https://gregmaxey.com/word_tip_pages/word_fields.html
    ' Charles Kenyon 10 November 2018
    ' https://answers.microsoft.com/en-us/msoffice/forum/all/force-all-documents-to-be-edited-in-uk-english/df6d1f8e-5426-49d9-bea0-5620d0208294
    ' Changes proofing language to Spanish in all stories of document
    Dim rngStory As Word.range
    Dim lngValidate As Long ' do not know purpose of this
    Dim oShp As Shape
    Dim oTOC As TableOfContents, oToa As TableOfAuthorities, oTof As TableOfFigures
    lngValidate = ActiveDocument.Sections(1).Headers(1).range.StoryType
    For Each rngStory In ActiveDocument.StoryRanges
      'Iterate through all linked stories
      Do
        On Error Resume Next
        rngStory.LanguageID = wdSpanish
        Select Case rngStory.StoryType
          Case 6, 7, 8, 9, 10, 11
            If rngStory.ShapeRange.Count > 0 Then
              For Each oShp In rngStory.ShapeRange
                If oShp.TextFrame.HasText Then
                   oShp.TextFrame.TextRange.LanguageID = wdSpanish
                End If
              Next
            End If
          Case Else
            'Do Nothing
        End Select
        On Error GoTo 0
        'Get next linked story (if any)
        Set rngStory = rngStory.NextStoryRange
      Loop Until rngStory Is Nothing
      Next
End Sub



Use Replace in Word or the vb Editor to replace “Spanish” with the appropriate constant. I.e., “EnglishUS” for the Constant wdEnglishUS. Here is a list of the language constants:
https://docs.microsoft.com/en-us/office/vba/api/word.wdlanguageid
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Powerpoint language detection settings Roser Barcelo PowerPoint 1 05-18-2018 08:24 AM
Excel Language Settings pinky25 Excel 0 07-11-2016 02:01 AM
problems with language settings Language settings change on auto Deliriumdive Word 2 06-20-2012 04:22 PM
Language settings Gabbyt PowerPoint 1 12-01-2010 02:30 AM
problems with language settings Language settings on office 2007 rg0 Office 1 03-30-2010 06:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft