J Johan Sep 17, 2009 #1 Excel 2007 - is it possible to assign macros to shortcut keys such as Ctrl +1, Ctrl +2 etc?
P Peter T Sep 17, 2009 #3 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
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