View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default disable 2003 shortcutkeys

I can't assign shortcut keys that have been set aside to process 2003
shortcuts.


Not sure I understand. OnKey works in Excel 2007 as in earlier versions to
capture any Excel shortcut key, e.g.:

Sub AssignCtrlS()
Application.OnKey "^s", "MySub"
End Sub

Sub MySub()
MsgBox "MySub running"
End Sub


--
Jim
"Shawn" wrote in message
...
|I have created a new ribbon in 2007 thanks to the help of Ron De Bruin.
|
| My problem is I can't assign shortcut keys that have been set aside to
| process 2003 shortcuts.
|
| How can I avoid this?
|
|
| Thanks,
|
| Shawn
|