View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joshua Joshua is offline
external usenet poster
 
Posts: 16
Default Assign Excel Menu to Shortcut Key

How do I assign an Excel menu item to a shortcut using VBA?

For example, I would like to add a procedure that inserts a worksheet
when the user presses Ctrl + Shift + I, instead of having to go to
through the native excel commands of Alt, then I, then W, or using the
mouse to navigate to Insert, then Worksheet

Thanks,

Joshua.