Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Attempting to make the regular enter key behave as if you press Alt-Enter, in
responce to someones post about how to do this. Pressing the standard enter key (not the numeric keypad enter) causes an infinite loop. The screen flickers with an hour-glass after pressing enter. Ctrl-Break stops the code and it is always on the Sub AltEnterRtn() line. Can anyone explain what is going on behind the scenes that causes this? Sub SetKey() Application.OnKey "~", "AltEnterRtn" End Sub Sub ResetKey() Application.OnKey "~" End Sub Sub AltEnterRtn() Application.SendKeys "%~", True End Sub -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why doesn't ths VBA Code work? | Excel Programming | |||
How can I get this code to work? | Excel Programming | |||
Why my code do not work : - ( | Excel Programming | |||
Why my code do not work : - ( | Excel Programming | |||
Why my code do not work : - ( | Excel Programming |