LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I assign a CTRL + shortcut key to a menu item (paste speci. PaulGB Excel Discussion (Misc queries) 1 July 14th 08 03:19 AM
Assign shortcut key to existing Excel Macro PatCos Excel Programming 1 June 12th 08 12:00 AM
Run Excel macro from XP shortcut menu hmm Excel Programming 5 December 26th 07 07:50 AM
cannot right-click a shortcut menu in Excel John Excel Discussion (Misc queries) 10 April 18th 07 02:04 PM
Help with shortcut menu in Excel Helen Excel Discussion (Misc queries) 1 February 14th 07 08:15 PM


All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"