Hi All,

Why Data Validation is disabled on an international macro sheet? Can I do
anything to enable it?

Thanks,
Stefi

I wouldn't think so.

But I'm wondering why you're using an international macro sheet in the first
place?

Stefi wrote:

Hi All,

Why Data Validation is disabled on an international macro sheet? Can I do
anything to enable it?

Thanks,
Stefi

--

Dave Peterson

Well, I use Hungarian version Excel, and I'd like to create an application
that will be used in English XL version. Formulae in my environment are in
Hungarian and I thought that an international macro sheet will translate them
into English. It does but validation cannot be used. Do you know the right
way of overcoming language differences?

Regards,
Stefi


€žDave Peterson€� ezt Ã*rta:

I wouldn't think so.

But I'm wondering why you're using an international macro sheet in the first
place?

Stefi wrote:

Hi All,

Why Data Validation is disabled on an international macro sheet? Can I do
anything to enable it?

Thanks,
Stefi

--

Dave Peterson

I've never used excel except in USA English.

But from what I've read, most of the formulas will translate into whatever
language the user has.

There are exceptions--I think things like =Cell("filename",a1) won't translate
the text portion of the file.

John Green, Stephen Bullen, Rob Bovey and Robert Rosenberg have a chapter in one
of their books that deals with international issues.

They share that chapter he
http://www.bmsltd.co.uk/ExcelProgRef/default.htm

Look for this link:
Chapter 22 - International Issues


Stefi wrote:

Well, I use Hungarian version Excel, and I'd like to create an application
that will be used in English XL version. Formulae in my environment are in
Hungarian and I thought that an international macro sheet will translate them
into English. It does but validation cannot be used. Do you know the right
way of overcoming language differences?

Regards,
Stefi

€žDave Peterson€� ezt Ã*rta:

I wouldn't think so.

But I'm wondering why you're using an international macro sheet in the first
place?

Stefi wrote:

Hi All,

Why Data Validation is disabled on an international macro sheet? Can I do
anything to enable it?

Thanks,
Stefi

--

Dave Peterson


--

Dave Peterson

And I think that the Analysis toolpak functions have trouble, too.

Each time I write a message about international issues, Ron de Bruin usually
comes by and corrects me. So keep an eye out for Ron's followup!

Dave Peterson wrote:

I've never used excel except in USA English.

But from what I've read, most of the formulas will translate into whatever
language the user has.

There are exceptions--I think things like =Cell("filename",a1) won't translate
the text portion of the file.

John Green, Stephen Bullen, Rob Bovey and Robert Rosenberg have a chapter in one
of their books that deals with international issues.

They share that chapter he
http://www.bmsltd.co.uk/ExcelProgRef/default.htm

Look for this link:
Chapter 22 - International Issues


Stefi wrote:

Well, I use Hungarian version Excel, and I'd like to create an application
that will be used in English XL version. Formulae in my environment are in
Hungarian and I thought that an international macro sheet will translate them
into English. It does but validation cannot be used. Do you know the right
way of overcoming language differences?

Regards,
Stefi

€žDave Peterson€� ezt Ã*rta:

I wouldn't think so.

But I'm wondering why you're using an international macro sheet in the first
place?

Stefi wrote:

Hi All,

Why Data Validation is disabled on an international macro sheet? Can I do
anything to enable it?

Thanks,
Stefi

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson