Map Keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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


Stephanie said:
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
Click to expand...
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.
 
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


Stephanie said:
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
Click to expand...
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
 
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
 
Back
Top