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