SHIFT G

P

Palle

I have suddenly a problem on my hands. Whenever I press SHIFT + "G" the
program search for data. This is very irritating as I write a lot of names
(beginning with capital letters) in a excel sheet. How can I stop this
"service" ??


Best regards

Palle
 
E

Earl Kiosterud

Palle,

This sounds like a problem with Excel and the keyboard. There are no Excel or user macro
shortcuts that use Shift -- that's for upper case characters. Macro shortcuts use Ctrl or
Ctrl + Shift. Usually when Microsoft programs get messed up with the keyboard, restarting
them clears it. Also, they never seem to happen with a single key. Try other keys with
SHift.

It is possible that an OnKey is in effect, but that vanishes when you close Excel. If a
macro is starting automatically when you start Excel and doing Application.OnKey "G"
"some_macro_name" then you'd have this problem.

Try Application.OnKey "G"

You can do it in the Immediate window, or in a sub. If that fixes it, then you know some
nefarious evildoer has set up an OnKey.
 
Top