Responding to Keypress event on a sheet
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. |
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. |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com