ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   change language setting using VBA code (https://www.excelbanter.com/excel-worksheet-functions/137679-change-language-setting-using-vba-code.html)

UB

change language setting using VBA code
 
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


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com