Map Keys

[Guest]

Does anyone know if it is possible to change the function of a key in Excel? We are using a protected worksheet with a lookup table and want to be able to get to the next cell without having to leave the number keypad. We were hoping to change the + key to function like the tab key

We thought about recording a macro and assigning a shortcut key, but those can only be CTR+ or CTRL+SHIFT+

Any ideas

I would appreciate any.

 

[Ron de Bruin]

Hi Stephanie

Maybe you can use this

You can use the Enter key on your numeric keyboard to run
the macro "yourmacro"
See the VBA help for OnKey

Application.OnKey "{ENTER}", "yourmacro"


--
Regards Ron de Bruin
http://www.rondebruin.nl

Does anyone know if it is possible to change the function of a key in Excel? We are using a protected worksheet with a lookup

table and want to be able to get to the next cell without having to leave the number keypad. We were hoping to change the + key to
function like the tab key.

 

[Guest]

Ron

That was a great suggestion, but I couldn't get it to work. I will keep trying

Thanks
Stephani

----- Ron de Bruin wrote: ----

Hi Stephani

Maybe you can use thi

You can use the Enter key on your numeric keyboard to ru
the macro "yourmacro
See the VBA help for OnKe

Application.OnKey "{ENTER}", "yourmacro


--
Regards Ron de Brui
http://www.rondebruin.n

Does anyone know if it is possible to change the function of a key in Excel? We are using a protected worksheet with a looku

table and want to be able to get to the next cell without having to leave the number keypad. We were hoping to change the + key t
function like the tab key

 

[Ron de Bruin]

Hi Stephanie

You must run this line each time you open the workbook and
reset it when you close the workbook.
You can use the events in the Thisworkbook module to do this

Private Sub Workbook_Activate()
Application.OnKey "{ENTER}", "yourmacro"
End Sub

Private Sub Workbook_Deactivate()
' reset it to his normal meaning
Application.OnKey "{ENTER}"
End Sub

Copy the macro (yourmacro) in a normal module