title: Set Workbook Language in VBA Excel
body: <p>I have a workbook that gets copied to different users with different regional language settings.</p>
  
  <p>The problem I have is, that because of the regional settings, some the macros i build wont work because they refer to translated values.</p>
  
  <p>Examples are Date names and the value for Year.
  (Year to Jaar.)</p>
  
  <pre><code> ActiveSheet.PivotTables("OpenPO").PivotFields("Years").ShowDetail = False
  </code></pre>
  
  <p>This refers to selected data inside a pivot table named Year in the original workbook. however this gets automaticly translated into the language of the user.</p>
  
  <p>To solve this I was hoping I could lock or set this specific workbooks language.</p>
  
  <p>unfortunately it is not an option to,
  run the Macro before copy,
  Set regional settings for every user,
  set Excels regional settings for every user,
  rewrite the macro's for every language.</p>
  
  <p>I have been searching for a long time to find a solution but have yet to find an answer. I really hope someone on here can help me.</p>
  
  <p>My most desired solution would be a simple VBA code to set the language of the workbook.</p>