View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro

Say in module1 we have:

Sub hello()
MsgBox ("HELLO")
End Sub

running this:

Sub setshort()
Application.OnKey "+^{F}", "module1.hello"
End Sub


will assign the shortcut CNTRL-SHIFT-F to it
--
Gary''s Student - gsnu200726