| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pressing enter to change cell | Excel Discussion (Misc queries) | |||
| WYA Converts to WAY after pressing enter ket | Excel Discussion (Misc queries) | |||
| Pressing Enter Key | Setting up and Configuration of Excel | |||
| Cursor not to move when pressing the enter key | Excel Programming | |||
| How do I follow a hyperlink by just pressing "enter"? | Excel Discussion (Misc queries) | |||
Threaded Mode
