Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnKey
I am working with OnKey with Enter & ~. My procedure works great.
The procedure reviews the sheet name and processes code if that particular sheet is the ActiveSheet (i.e. if Sheet X is the activesheet), then procedure is processed. I would like to modify the procedure to retain ALL of the normal "Enter" & "~" cursor activities on any other sheet (i.e. if user has a range selected on Sheet A, then cursor scrolls thru the selected cells in its normal manner, or if you press enter and your Application.MoveAfterReturnDirection is set to Down, your cursor moves down). Currently, my procedure does nothing when enter is pressed on a worksheet other than Sheet X. Thank you. MSweetG222 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnKey
Use the worksheet activate events in each sheet to either set or unset the
key macro. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "MSweetG222" wrote in message ... I am working with OnKey with Enter & ~. My procedure works great. The procedure reviews the sheet name and processes code if that particular sheet is the ActiveSheet (i.e. if Sheet X is the activesheet), then procedure is processed. I would like to modify the procedure to retain ALL of the normal "Enter" & "~" cursor activities on any other sheet (i.e. if user has a range selected on Sheet A, then cursor scrolls thru the selected cells in its normal manner, or if you press enter and your Application.MoveAfterReturnDirection is set to Down, your cursor moves down). Currently, my procedure does nothing when enter is pressed on a worksheet other than Sheet X. Thank you. MSweetG222 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnKey
Thank you very much.
I am making the changes now. -- Thx MSweetG222 "Bob Phillips" wrote: Use the worksheet activate events in each sheet to either set or unset the key macro. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "MSweetG222" wrote in message ... I am working with OnKey with Enter & ~. My procedure works great. The procedure reviews the sheet name and processes code if that particular sheet is the ActiveSheet (i.e. if Sheet X is the activesheet), then procedure is processed. I would like to modify the procedure to retain ALL of the normal "Enter" & "~" cursor activities on any other sheet (i.e. if user has a range selected on Sheet A, then cursor scrolls thru the selected cells in its normal manner, or if you press enter and your Application.MoveAfterReturnDirection is set to Down, your cursor moves down). Currently, my procedure does nothing when enter is pressed on a worksheet other than Sheet X. Thank you. MSweetG222 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OnKey | Excel Programming | |||
Help with using OnKey | Excel Programming | |||
onkey help | Excel Programming | |||
onkey | Excel Programming | |||
Onkey | Excel Programming |