Prev: VBA, refrencing a range
Next: VBA code to paste data based on condition
From: Subodh on 8 Mar 2010 19:53
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.
From: Peter T on 9 Mar 2010 04:09
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" <getsubodh(a)gmail.com> wrote in message
news:2bc40d21-eb6d-4f93-bf44-c079d025306a(a)t31g2000prh.googlegroups.com...
>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.


 | 
Pages: 1
Prev: VBA, refrencing a range
Next: VBA code to paste data based on condition