View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Responding to Keypress event on a sheet

See the reply to your similar post on 02 March, with subject
"To disable pressing of Enter key on a sheet"

Regards,
Peter T

"Subodh" wrote in message
...
I want code to respond to the keypress event on a worksheet.
How can i do that??
Actually i need a code that runs a predefined when some key is pressed
while the sheet is active.
In particular, i want to disable the enter key (ie. the selection of
cell should not shift to the next cell) and then
it should run a macro.
Thanks in advance.