ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SHIFT G (https://www.excelbanter.com/excel-discussion-misc-queries/181371-shift-g.html)

Palle

SHIFT G
 
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
--
Hej ho hej ho

David Biddulph[_2_]

SHIFT G
 
Have you allocated Shift G as a keyboard shortcut for a macro?
--
David Biddulph

"Palle" wrote in message
...
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
--
Hej ho hej ho




Earl Kiosterud

SHIFT G
 
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.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Palle" wrote in message
...
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
--
Hej ho hej ho





All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com