Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Options in 2003 Jeremy Excel Discussion (Misc queries) 1 April 14th 10 07:36 PM
Excel 2003 format menu disable it Setting up and Configuration of Excel 1 October 29th 07 02:15 PM
How to disable Security Warning for Excel 2003 with NO macros Marjie Setting up and Configuration of Excel 2 November 1st 05 07:19 PM
Disable format painter in excel 2003 tenchsama New Users to Excel 1 February 8th 05 12:53 AM
Menu Items and Disable/Enable in Excel 2003 [email protected] Excel Programming 1 February 6th 04 08:14 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"