Dear all,

I have tremendous troubles with a Dutch version of Office2007 excel. All
functions are in Dutch and I turn nuts on it. So lets say the witch i know
as Value() now becomes WAARDE(). Now I thought there was nothing to do about
this, but I do start wonder if i can to change a setting some where to turn
the Dutch language shell off since I found that once I use the below
function it returns the function in English.

<Q
Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function
<UQ

Can someone let me know if and how I could turn off the Dutch language shell
laying over the functions so that I will have the common English and most
likely native function names.

Further I kill myself finding a way to get my own functions working in 2007.
I saven them in Modules in 'Personal.XLMS' start-up file/directory, turned
off all securities and still Excel 2007 does not reconize them as i was used
to with Excel 2003.......... can anyone reveal the trick.

All help will be highly appriciated.

Ludovic


--



-------------------------------
This e-nonsense has been sent using a Strawberry.
-------------------------------

Hallo Ludovic

You can install a language pack of Office 2007 if you want
http://office.microsoft.com/en-us/su...113661033.aspx

Is your personal file pasword protected ??

Groeten Ron

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vsn" <vsn at hotmail wrote in message ...
Dear all,

I have tremendous troubles with a Dutch version of Office2007 excel. All
functions are in Dutch and I turn nuts on it. So lets say the witch i know
as Value() now becomes WAARDE(). Now I thought there was nothing to do about
this, but I do start wonder if i can to change a setting some where to turn
the Dutch language shell off since I found that once I use the below
function it returns the function in English.

<Q
Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function
<UQ

Can someone let me know if and how I could turn off the Dutch language shell
laying over the functions so that I will have the common English and most
likely native function names.

Further I kill myself finding a way to get my own functions working in 2007.
I saven them in Modules in 'Personal.XLMS' start-up file/directory, turned
off all securities and still Excel 2007 does not reconize them as i was used
to with Excel 2003.......... can anyone reveal the trick.

All help will be highly appriciated.

Ludovic


--



-------------------------------
This e-nonsense has been sent using a Strawberry.
-------------------------------

Ron,

I am looking at the language package, even I do think it is strange that the
function as shown below shows/reports a build in formula in a different
language as it is typed. I would think this is caused by a shell which came
with the Dutch version i have and you would expect that you could turn off
this shell instead of installing a language pack.

I have not protected my personal file, should I do this? Currently I have no
access to my office2007 which is in the office so at this point from hom i
am unable to try this.

Thx,
Ludovic

"Ron de Bruin" wrote in message
...
Hallo Ludovic

You can install a language pack of Office 2007 if you want
http://office.microsoft.com/en-us/su...113661033.aspx

Is your personal file pasword protected ??

Groeten Ron

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vsn" <vsn at hotmail wrote in message
...
Dear all,

I have tremendous troubles with a Dutch version of Office2007 excel. All
functions are in Dutch and I turn nuts on it. So lets say the witch i
know as Value() now becomes WAARDE(). Now I thought there was nothing to
do about this, but I do start wonder if i can to change a setting some
where to turn the Dutch language shell off since I found that once I use
the below function it returns the function in English.

<Q
Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function
<UQ

Can someone let me know if and how I could turn off the Dutch language
shell laying over the functions so that I will have the common English
and most likely native function names.

Further I kill myself finding a way to get my own functions working in
2007. I saven them in Modules in 'Personal.XLMS' start-up file/directory,
turned off all securities and still Excel 2007 does not reconize them as
i was used to with Excel 2003.......... can anyone reveal the trick.

All help will be highly appriciated.

Ludovic


--



-------------------------------
This e-nonsense has been sent using a Strawberry.
-------------------------------

De enige manier is om het taal pakket er op te zetten als je Engelse funkties wil gebruiken

Je kan dit wel gebruiken

Cell.FormulaLocal
Dit geeft je de Nederlandse function


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vsn" <vsn at hotmail wrote in message ...
Ron,

I am looking at the language package, even I do think it is strange that the
function as shown below shows/reports a build in formula in a different
language as it is typed. I would think this is caused by a shell which came
with the Dutch version i have and you would expect that you could turn off
this shell instead of installing a language pack.

I have not protected my personal file, should I do this? Currently I have no
access to my office2007 which is in the office so at this point from hom i
am unable to try this.

Thx,
Ludovic

"Ron de Bruin" wrote in message
...
Hallo Ludovic

You can install a language pack of Office 2007 if you want
http://office.microsoft.com/en-us/su...113661033.aspx

Is your personal file pasword protected ??

Groeten Ron

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vsn" <vsn at hotmail wrote in message
...
Dear all,

I have tremendous troubles with a Dutch version of Office2007 excel. All
functions are in Dutch and I turn nuts on it. So lets say the witch i
know as Value() now becomes WAARDE(). Now I thought there was nothing to
do about this, but I do start wonder if i can to change a setting some
where to turn the Dutch language shell off since I found that once I use
the below function it returns the function in English.

<Q
Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function
<UQ

Can someone let me know if and how I could turn off the Dutch language
shell laying over the functions so that I will have the common English
and most likely native function names.

Further I kill myself finding a way to get my own functions working in
2007. I saven them in Modules in 'Personal.XLMS' start-up file/directory,
turned off all securities and still Excel 2007 does not reconize them as
i was used to with Excel 2003.......... can anyone reveal the trick.

All help will be highly appriciated.

Ludovic


--



-------------------------------
This e-nonsense has been sent using a Strawberry.
-------------------------------