OnKey

[MSweetG222]

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

 

[Bob Phillips]

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]

Thank you very much.
I am making the changes now.