Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-29-2020, 11:27 AM
Ulodesk Ulodesk is offline Proofing language for one template Windows 10 Proofing language for one template Office 2016
Word 2013 Expert Cert
Proofing language for one template
 
Join Date: Sep 2009
Location: Virginia
Posts: 788
Ulodesk is on a distinguished road
Default Proofing language for one template

For work, in a proposals department using Office 365 on SharePoint, one proposal will require Canadian English rather than our default American. I went to set it, but I do not wish to set it for every Word document I open, which seemed to be indicated.



The online (SharePoint) Word document is made from a copy of a custom template (dotx) that we use. It was in that template, online, that I attempted to make the change, planning then to update the document from that, or create the same proofing setting in it, if that's what's required.

But is this possible? I see the choice of "removing" American English as a proofing language, but don't know what that means with regard to my concerns above. This one proposal is a "one-off" in this regard, though it's possible we'll see others from Canada, but only occasionally.

Thanks.
__________________
Sine scientia ars nihil est
Reply With Quote
  #2  
Old 07-29-2020, 02:57 PM
Charles Kenyon Charles Kenyon is offline Proofing language for one template Windows 10 Proofing language for one template Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,928
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

Make your proposal a Word template with the styles set for Canadian English.
See Proofing Language Keeps Changing - Solutions - How can I keep my proofing language from changing? by Charles Kenyon.
Use the second macro on that page to set the proofing language for your template.


Note, pasted text is going to carry other language settings unless pasted as text only.
Reply With Quote
  #3  
Old 07-30-2020, 07:31 AM
Ulodesk Ulodesk is offline Proofing language for one template Windows 10 Proofing language for one template Office 2016
Word 2013 Expert Cert
Proofing language for one template
 
Join Date: Sep 2009
Location: Virginia
Posts: 788
Ulodesk is on a distinguished road
Default Further help

Charles, thank you, but I am apparently not understanding something. The macro appears to work, but after closing and reopening the template, it has reverted to US English.

Since the online dotx is a copy of one I made locally, I opened the local one first to create the change, planning to then upload and replace the old one. When the above-cited problem occurred with the former, I tried making a dotm and installing the macro in This Document instead of Module 1, since the latter is based in the Normal template, but the same thing occurred. (I barely know my way around macros, and am no coder; please forgive any gaffs here.) Meanwhile, I discovered that, for whatever reason, a new docx opened normally from Word (from default Normal) has retained the English (Canada) choice. Well, at least it stuck somewhere, but that has to be changed back.

What results from the macro is, Canada appears above United States, both checked at the top of the proofing language dialogue box, with Canada highlighted. After saving, closing, and reopening, Canada remains at the top, but United States is highlighted. I presume this means that both spellings are acceptable, but Word starts looking for US or something?

I need more guidance, please. If I have not provided adequate information, please let me know.
Thank you.
__________________
Sine scientia ars nihil est
Reply With Quote
  #4  
Old 07-30-2020, 09:06 AM
Charles Kenyon Charles Kenyon is offline Proofing language for one template Windows 10 Proofing language for one template Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,928
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

If you can attach it here, I'll try to run the macro and see what I get.
How to attach a screenshot or file in this forum.
You may have to put it in a compressed (zip) folder.
Reply With Quote
  #5  
Old 07-30-2020, 09:13 AM
Ulodesk Ulodesk is offline Proofing language for one template Windows 10 Proofing language for one template Office 2016
Word 2013 Expert Cert
Proofing language for one template
 
Join Date: Sep 2009
Location: Virginia
Posts: 788
Ulodesk is on a distinguished road
Default Template

Charles, I've stripped out sensitive info to be replaced if you have better luck than I.

Thanks.
Philip
Attached Files
File Type: dotx Macro text MS Template.dotx (61.2 KB, 1 views)
__________________
Sine scientia ars nihil est

Last edited by Ulodesk; 07-30-2020 at 09:16 AM. Reason: Change to doc
Reply With Quote
  #6  
Old 07-30-2020, 09:34 AM
Charles Kenyon Charles Kenyon is offline Proofing language for one template Windows 10 Proofing language for one template Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,928
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

Try the attached.

I ran the following macro:
Code:
Sub StyleEnglishCanadian()
'   Written 21 April  2018
'   Charles Kenyon
'   Intended to set all styles to EnglishCanadian, proofing, not automatitically update
'   Language IDs https://docs.microsoft.com/en-us/office/vba/api/word.wdlanguageid
'
    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
        Select Case aStyle.NameLocal
            Case "TOC 1", "TOC 2", "TOC 3", "TOC 4", "TOC 5", "TOC 6", "TOC 7", "TOC 8", "TOC 9"
                Let aStyle.AutomaticallyUpdate = True
            Case Else
                Let aStyle.AutomaticallyUpdate = False
        End Select
        Let aStyle.LanguageID = wdEnglishCanadian
        Let aStyle.NoProofing = False
    Next aStyle
    ActiveDocument.UpdateStylesOnOpen = False ' For information on using this line, see:
'       http://www.shaunakelly.com/word/sharing/willmyformatchange.html
    On Error GoTo -1
End Sub
Attached Files
File Type: dotx Macro text MS Template.dotx (61.1 KB, 1 views)
Reply With Quote
  #7  
Old 07-30-2020, 10:02 AM
Ulodesk Ulodesk is offline Proofing language for one template Windows 10 Proofing language for one template Office 2016
Word 2013 Expert Cert
Proofing language for one template
 
Join Date: Sep 2009
Location: Virginia
Posts: 788
Ulodesk is on a distinguished road
Default Template

Thank you again. As far as I can see, you are getting the same result as I did, with both US and Canada at the top of the proofing languages dialogue but with Canada selected, except that yours seems to hold. What's interesting is that, when I copied the macro, installed it, and ran it in the copy I sent you, it behaved as before, effective until; I closed and reopened the document.

Well, I'll start with yours, replace the data I had removed from it, and see how things go.

As always, I appreciate your generous assistance.

Philip
__________________
Sine scientia ars nihil est
Reply With Quote
  #8  
Old 07-30-2020, 11:02 AM
Charles Kenyon Charles Kenyon is offline Proofing language for one template Windows 10 Proofing language for one template Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,928
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

Hope it works for you.
Reply With Quote
  #9  
Old 07-30-2020, 01:07 PM
Ulodesk Ulodesk is offline Proofing language for one template Windows 10 Proofing language for one template Office 2016
Word 2013 Expert Cert
Proofing language for one template
 
Join Date: Sep 2009
Location: Virginia
Posts: 788
Ulodesk is on a distinguished road
Default

All seems well, after making the switch on SP. Someday, years from now, it will suddenly occur to me what the problem was in the template I sent you that kept the change from holding. Anyway, the macro will undoubtedly come in handy again. Much obliged.
__________________
Sine scientia ars nihil est
Reply With Quote
  #10  
Old 07-30-2020, 02:52 PM
Charles Kenyon Charles Kenyon is offline Proofing language for one template Windows 10 Proofing language for one template Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,928
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

I'm glad to hear it.


Keep in mind that if you paste anything into the document, you need to do it as plain text or select any pasted text and be sure to set the language attribute for that text.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Proofing Language Changes do Not Take Effect Andrew H Word 8 01-03-2018 07:32 AM
Proofing language for one template Proofing language issues kiyap Word 3 10-01-2016 08:24 AM
Can't set proofing language Mayda89 PowerPoint 3 01-28-2016 11:00 AM
Proofing language for one template Adding German as proofing language M. Dino Word 1 11-14-2014 04:19 PM
Proofing language for one template proofing language wont change BigOldArt Word 2 01-18-2013 01:22 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:37 AM.


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