View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Subodh Subodh is offline
external usenet poster
 
Posts: 99
Default To disable pressing of Enter key on a sheet

I have a worksheet
I want to disable pressing of Enter in the Sheet (ie. after pressing
Enter Key the selection of the cell should not go to the next cell)
and it should run a macro.
I have written the macro. Now, I want to run that macro when the User
presses the Enter Key.
It is similar to Keypress event in forms. I worked out and found that
there is code to disable the right click and to run other macro on
right click but i could not find any way to disable the enter key.