Assign macro to shortcut keys "ctrl + 1"?

's Computer Specifications

Excel 2007 - is it possible to assign macros to shortcut keys such as
Ctrl +1, Ctrl +2 etc?

's Computer Specifications

Hello
No you can't, shorcut keys expect letters.
HTH
Cordially
Pascal

"Johan" <(E-Mail Removed)> a écrit dans le message de news:
135c2cf1-79f3-4cf4-97fc-2c109a7236cc...oglegroups.com...
> Excel 2007 - is it possible to assign macros to shortcut keys such as
> Ctrl +1, Ctrl +2 etc?

's Computer Specifications

Application.OnKey "^1", "myMacro"
Application.OnKey "^1" ' to clear it

Some users might not appreciate your hi-jacking the built-in shortcut for
the format menu!

Regards,
Peter T

"Johan" <(E-Mail Removed)> wrote in message
news:135c2cf1-79f3-4cf4-97fc-(E-Mail Removed)...
> Excel 2007 - is it possible to assign macros to shortcut keys such as
> Ctrl +1, Ctrl +2 etc?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ReVIEW (Erratum): some shortcut keys not working anymore-----help""""""""PhpApach...WORK WELL!!!!	wbrowse@gmail.com	Windows XP Help	0	13th Apr 2007 12:29 PM
Can i modify default shortcut keys. E.g. "Ctrl + Enter" to send ms	=?Utf-8?B?Q2hyaXMgQw==?=	Microsoft Outlook Discussion	1	27th Jul 2006 12:59 PM
Keyboard shortcut (Ctrl+Alt+C) "lost", can't re-assign	David Winter	Windows XP General	3	24th Jun 2006 12:11 AM
not getting the "assign macro" shortcut	JC Home	Microsoft Excel Programming	3	2nd Oct 2004 11:07 PM
Create macro for "Ctrl + [" shortcut key??	nilsstyf	Microsoft Excel Discussion	1	23rd Oct 2003 12:45 AM