Thread: change language setting using VBA code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UB UB is offline
external usenet poster
  
Posts: 120
Default 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
Reply With QuoteReply With Quote