Assign macro to shortcut keys "ctrl + 1"?

  • Thread starter Thread starter Johan
  • Start date Start date
J

Johan

Excel 2007 - is it possible to assign macros to shortcut keys such as
Ctrl +1, Ctrl +2 etc?
 
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
 
Back
Top