Maybe have a look in the vba help index for ONKEY

--
Don Guillett Excel MVP
SalesAid Software

"Keith" wrote in message
...
I have a named range that covers data in columns A and B. (A) contains
acompany names and (B) contains the Town the company is in.

Users have the ability to delete entries that aren't theirs by selecting
both (A) and (B) across the row, right clicking and selecting delete.
Finally
when asked select to shift the cells us. To add a new entry they add it to
the very bottom of the list then click on a button that runs a macro to
re-sort the list.

This works fine in practice but some users are deleting the company only
and
not the town, causing things to go wrong.

How can I force the user to select both columns when deleting. It might
not
always be a single line they want to delete. It might be a whole block of
entries.

Anybody got any ideas?