Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OnKey Hernan Excel Programming 2 January 11th 06 04:18 PM
Help with using OnKey keithb Excel Programming 1 December 19th 05 11:03 PM
onkey help wardy Excel Programming 0 July 20th 04 05:49 PM
onkey peter Excel Programming 2 March 2nd 04 07:34 PM
Onkey Jase Excel Programming 1 November 17th 03 11:07 PM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"