change language setting using VBA code

U

ub

Hi
I am writing a vba code were when the woksheet is opened, it will check the
language setting, if it is not english, it will change the setting to english
or else do nothing.
It is not working, please advise

Set objLangSet = Application.LanguageSettings
If objLangSet.LanguageID(msoLanguageIDInstall) <> 1033 Then
objLangSet.LanguageID(msoLanguageIDInstall) = 1033
Else
objLangSet.LanguageID(msoLanguageIDInstall) = 1033
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing language for spell check not working? 1
Working outlook via vba code with xlsx - error 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Convert old wordbasic code into VBA that will run now 0
VBA word change keys 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
English/French settings 1
Get the right language when inserting a date 2

Top