Thread: Key event
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 22
Default Key event

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!



.