Hi,

I have an Excel calendar that is with a heep of formulas and active control can show any year's calendar as per the user's wish.
Also, with conditional formatting the weekend days are coloured, the Easter is calculated for the actual year and coloured, etc., etc.

There is a particular formula in the calendar that contains the formatting definition: "DDD" that is responsible to make the cell showing the weekday with three digits, e.g Mon, Tue, etc. =TEXT(A2,"DDD")

I am working for an international company so I have colleagues in Hungary, the States, Germany, Australia, all over the World. So, when I started to share this ever-calendar I experienced it was working properly only with the English language setting Windows.
Cause: In the various language settings, there are different entries required for the same function: in the German version you have to apply "TTT" i nthe Hungarian it is "nnn" and so on.

So what I need now is within Excel an Auto_Open that looks into the MS Windows launguage setting and dependant on what it finds, it will select the appropriate syntax for that particular formula in a form of entering that into a cell, which will be referenced by the formulas.

Is that possible?

Thanks for your attention

Gábor