Change Office display language with VBA

K

KeepTrying

Active Member
Joined
Aug 19, 2012
Messages
276
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi Guys,

Small issue yet annoying: I use Excel/VBA in different languages and I'd like a solution where I run a VBA code and display language updates automatically (let's say from English to German).
I'm talking about this setting in Excel:

1594638884320.png


I assume it can be done with some API or editing appropriate registry value but I'm not a master of these stuff.
Thanks in advance for your help and have a great day.
 
Sort by date Sort by votes
You're welcome, better to accept the hassle, than risk having to wipe your computer & restoring from original spec.
 
Upvote 0

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
355
Jagadeshrao
J
P
  • Question Question
Excel/365 VBA crash issues recently
Replies
0
Views
458
picklefactory
P
I
  • Question Question
Show the "Edit Name" dialog from VBA for a specific Name
Replies
1
Views
834
Jaafar Tribak
Jaafar Tribak
frabulator
  • Question Question
Change the Office Theme via VBA with RegEdit
Replies
1
Views
2K
frabulator
frabulator
E
  • Question Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
2K
jkpieterse
jkpieterse

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top