Assign macro to shortcut keys "ctrl + 1"?

J

Johan

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

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Designate font as italic of another 0
Menu Macro Not Executing - Need Help 1
VBA word change keys 0
I have nearly run out of Shortcut Keys 4
Assigning function to Ctrl+Space and it worls wrongly 2
Assign Formatted Block of Text to Theme 0
How to disable Alt+s in Outlook 365 0
Assign shortleys to macro 0

Top