ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disable 2003 shortcutkeys (https://www.excelbanter.com/excel-programming/394445-disable-2003-shortcutkeys.html)

Shawn[_11_]

disable 2003 shortcutkeys
 
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


Jim Rech

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
|




All times are GMT +1. The time now is 10:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com