If you want to have that type of control, I suggest you fully protect your
sheet and handle all user interactions through Userforms. There is no
direct way to determine what has triggered a change event other than
indirect methods such as scanning through the sheet and making comparisons.

--
Regards,
Tom Ogilvy


"sai" wrote in message
oups.com...
Tom,

I see the logic of what you are suggesting.

The cells.count is usually much less than 65536 and is variable. But I
can get the cell count I need.

How do I distinguish between a move and say a delete? If the user
selects an entire column and hits delete, I want to be able to prevent
that. I want to allow only a move. Any ideas on how to trap the key
pressed or something like that I can use to judge user intention before
I exit sub?

Thanks for your response.

Sai