changing default shortcut - please help!

  • Thread starter Thread starter HeatherErin
  • Start date Start date
H

HeatherErin

I am trying to figure out how to change Ctrl+Page Down to a keyboar
shortcut that I can do with my left hand. Does anyone know the step
for changing the default shortcut keys
 
There is no built in way to change key assignments in Excel. You have to
use VB code:

''Run this to have Excel run DoPgDn when the function key F6 is pressed.
''See Help for OnKey and SendKeys
Sub SetPgDown()
Application.OnKey "{F6}", "DoPgDn"
End Sub

Sub DoPgDn()
Application.SendKeys "{PGDN}"
End Sub

--
Jim
"HeatherErin" <[email protected]>
wrote in message
|
| I am trying to figure out how to change Ctrl+Page Down to a keyboard
| shortcut that I can do with my left hand. Does anyone know the steps
| for changing the default shortcut keys?
|
|
| --
| HeatherErin
| ------------------------------------------------------------------------
| HeatherErin's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=34311
| View this thread: http://www.excelforum.com/showthread.php?threadid=540770
|
 
Back
Top