Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Perth, Western Australia, Australia
    Thanked 0 Times in 0 Posts

    Re: Shortcut Menus - Free Add-In (97, 2000, XP, 2003)

    Thank you unkamunka,
    It is a very useful shortcut collection.

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Vienna, Wien, Austria
    Thanked 0 Times in 0 Posts

    Shortcut Menus - Free Add-In (97, 2000, XP, 2003)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 17:15. to update links to</P>There are many right-click menus in Excel. They can, however, only be customised using VBA. The attached Add-In brings the most heavily used "hidden" dialogs and options within 1 or 2 clicks - rather than (generally) 3 or 4 clicks/keyboard strokes. There are also a few "side" features - such as a dialog for printing non-contiguous worksheets - and Romke Soldaat's (tweaked) code for floating Shortcut Menus permanently.

    The Add-In can be loaded from Tools|Add-Ins|Browse in Excel. Navigate to wherever you unzipped the attachment.

    9 Shortcut Menus are customised: Cell, Column, Row, Document (top bar of workbook [for maximised workbooks, icon at top left hand corner]), Formula Bar, System (icon at top left hand corner [a left click]), Worksheet Tabs (to left of tab names), Ply (tab names) and Desktop (behind non-maximised workbooks). The existing controls on the Menus are retained - although a few are relocated. For anyone who has already customised any of these Shortcut Menus, the Add-In will remove them altogether on loading. On unloading, the Add-In will restore the Shortcut Menus to their default settings.

    For anyone who wants to set up their own Shortcut Menus, searching in Excel's Online Help under Command Bars will yield references to various basic code snippets that can be adapted. More details of the individual controls available and the related icons can be found by running Jan-Karel <!profile=Pieterse>Pieterse<!/profile>'s xlMenuFunDict and/or John Green's CBList as well in a number of Excel programming books.

    The Add-In has been tested on (and adapted for) all versions of Excel from 97 onwards. It also works on foreign versions - although a number of the customised Menu captions will only display in English. Enjoy!

    Thanks to <!profile=HansV>HansV<!/profile>, <!profile=Brooke>Brooke<!/profile> and others too numerous to mention <img src=/S/grin.gif border=0 alt=grin width=15 height=15> for feedback during the testing phase.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts