Hello,

I have a user who is opening an excel sheet with some German
referenced and is getting an error message because it is referencing a
German keystroke. The problem code is below:

Application.OnKey "{ENDE}", "aendern"
Application.OnKey "{einfg}", "einfueg"
Application.OnKey "^{ENDE}", "aendern_voll"

Basically, his US setup does not recognize the keystrokes ENDE and
einfg (end and insert). I can change them to english and it works,
but I do not want to do this because this is a shared spreadsheet.

Is there a change I can make on his client that will enable this
coding?

Perhaps you can use:

Application.International(xlCountrySetting)

to run country specific code (US settings return 1).

--
Jim
"robkiolbasa" wrote in message
oups.com...
| Hello,
|
| I have a user who is opening an excel sheet with some German
| referenced and is getting an error message because it is referencing a
| German keystroke. The problem code is below:
|
| Application.OnKey "{ENDE}", "aendern"
| Application.OnKey "{einfg}", "einfueg"
| Application.OnKey "^{ENDE}", "aendern_voll"
|
| Basically, his US setup does not recognize the keystrokes ENDE and
| einfg (end and insert). I can change them to english and it works,
| but I do not want to do this because this is a shared spreadsheet.
|
| Is there a change I can make on his client that will enable this
| coding?
|