Thread: OnKey
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default 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