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

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

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