Greg,
Thanks for the information.
Looks like you figured it out as no button click is necessary to toggle the
"alternative" layout. However, I do not have the Input locales tab on
the Keyboard dialog/window. Two tabs only...Speed and Hardware.
I am using Windows XP with SP2.
I will now do some searches re windows/keyboard settings and/or
review the Windows installed settings.
Do you have any other suggestions?
Your help is much appreciated.
Regards,
Jim Cone


"Greg Wilson"
wrote in message
Jim,
I replicated similar with <Alt + <Shift and left mouse click when I had an
alternate keyboard layout selected. The button or message box apparently are
not actually relavent. The key + mouse click sequence appears to toggle
between the keyboard layout selections. For alternate keyboard layout
selections see:
Control Panel / Keyboard / Input locales tab / Installed input locales window.

Note the Hot key option in this dialog. The key + mouse click sequence
likely activates the toggling behaviour by design. After unselecting the
alternate keyboard layout option leaving only "English (United States)....US"
and pressing the Apply button the behaviour was removed. You could probably
just unselect the checkbox re the Hot key option (not tested).

Above based on a quick test only.
Regards,
Greg



"Jim Cone" wrote:

Hello,

The ~, ,@, # and | keys are assigned to other characters...

(~!@#$%^) becomes (¬!"£$%^) and the bar key changes to a tilde.

This occurs in the four Xl versions 97 thru 2003 that I have; if/when...

1. Add a button from the forms toolbar to a worksheet
or use a message box with an OK button.
2. Hold down the Alt and Shift keys and click the button.
(don't assign a macro to the button)

The keys are returned to their normal function by repeating the process.
Yes, OnKey will reset the keys, but just until the next time.
I also tried reinstalling XL 97 to no avail.
Am I alone in the wilderness having written too many lines of code? <g

Jim Cone
San Francisco, USA