Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding an item to right-click menu (Excel 00)

    Does anyone know how to add an item to the right-click menu for Excel? I know how to do it in Word but can't figure it out for Excel.

    Example: I downloaded a case changer add-in for Excel but would like it to appear on the right click menu. For some reason, it does appear on my right-click menu at work but not at home. Any ideas?
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding an item to right-click menu (Excel 00)

    Hi Sherry,
    Do you use the same version of Excel at home as you do at work? I think some of the index numbers of the shortcut menus are different between versions. Unfortunately, as this is an add-in you'll find it tricky to add the shortcut yourself as you'd need to know the name of the procedure it actually runs.
    One other thing to check - are you right-clicking on the same thing? There are different shortcut menus depending on whether your selection is a range, a whole row or column, a chart etc.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding an item to right-click menu (Excel 00)

    I use Office 97 at work and Office 2000 at home. Its the 2000 version that doesn't have the case changer on the right-click menu. And, yes, I am right-clicking on the same thing.

    Any suggestions?
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding an item to right-click menu (Excel 00)

    I guess you've got 2 choices (ignoring the option of trying to guess the name of the routine) - either create your own macro to do it and add that to your shortcut menu or, if the add-in was free, see if there's a 2000 version available.
    I would think that the routine to change case would be pretty simple if you wanted to do it yourself - I'm assuming it simply converts text from upper/lower/proper case to either of the other cases?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding an item to right-click menu (Excel 00)

    The attached is a pretty simplistic Excel 2000 version of a case change add-in - it only adds itself to the right-click cells shortcut menu not to any of the main toolbars, but I haven't protected the code so you can tweak it as necessary.
    Hope that helps.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding an item to right-click menu (Excel 00)

    That's great! I'll try it as soon as I get home.

    Thanks a lot!
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding an item to right-click menu (Excel 00)

    <P ID="edit" class=small>Edited by gwhitfield on 04-Jan-02 06:38.</P>Hyperlinks added

    What is neat about the case changer I am using is that it is an add-in (from <A target="_blank" HREF=http://go.compuserve.com/MSOfficeForum>http://go.compuserve.com/MSOfficeForum</A>) rather than a macro. I downloaded it from a post in this forum (from pieterse on Oct 9, 01 in answer to my post 80833). I checked the MSOfficeForum to see if they had one for Excel 2000 but didn't find one.

    When you install the add-in it creates a toolbar button that you can click and select from the various forms of case [upper, lower, title, etc.). For some reason in Office 97 it also appears on the right-click menu but doesn't in Excel 00.

    Right-clicking is much more convenient than having to run a macro.
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

Posting Permissions

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