If you are using one of the events, use the Target argument rather than
ActiveCell.

--
Regards,
Tom Ogilvy


"Marston" wrote in message
om...
I'm using ActiveCell to make determination of certain actions to take
in a tool.

What I've discovered is that if the user makes an entry into a cell
and hits the Tab key rather than the Enter key, it puts me into a
different cell and a different, undesired action.

How can I intercept the Tab and turn it into a shift?

Thanks in advance.

Marston

PS - has anyone else noticed that the Beta version of Google groups is
no longer updating as frequently as before. I used to be 10-15
minutes, but now I'm not seeing anything for days.