changing default shortcut - please help!
 

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...o&userid=34311
View this thread: http://www.excelforum.com/showthread...hreadid=540770

changing default shortcut - please help!
 

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"
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...o&userid=34311
| View this thread: http://www.excelforum.com/showthread...hreadid=540770
|