Why not unlock the cells you will allow the user to alter, then protect the
worksheet.

--
Regards,
Tom Ogilvy

"Greg" wrote in message
...
I want to let the user delete selected text/content in
selected cells. However, I want the user to be unable to
delete rows at a time... I hope that makes sense... I
don't want the user to be able to select a row(s) and hit
delete...

Thanks!

-----Original Message-----
Greg,

There is really no good way to do this. Perhaps if you
describe
why you need to trap the Delete key, some one could come
up with
a suitable workaround (e.g., the Change event procedure).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Greg" wrote in
message
...
How can I get a key press [down | up] event in Excel?
Or,
how do I know if the delete key was pressed?

Thanks!



.