+ Reply to Thread
Results 1 to 4 of 4

Custom Right Click Menu and Sub-menu (disable inbuilt right click menu item)

  1. #1
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2010
    Posts
    271

    Custom Right Click Menu and Sub-menu (disable inbuilt right click menu item)

    This workbook has Module One having Macro to add Menu to Right Click Command.

    Please Login or Register  to view this content.
    All Contextmenu Control under Command Bars appears above Cut, Copy etc inbuild Microsoft Office Menu items

    Currently it is not grouped and such custom command bars are expanding, hence need to have it under Sub-menu, and seniors help sought.

    Help -

    How Do I make Three Major CommandBars Say -
    1) PrepareData
    2) Report Data
    3) CustomReport

    Such that existing Command Bars appear under item 2) Report Data, and how do I group similar Command bars to call upon Macro that would appear
    under item 1) Prepare Data, and 3) CustomReport

    So, when I Right Click in Excel, above Cut, Copy etc in-built command bars, only above three items appear at top, and rest of other are grouped under 2) and son on

    Is there also a way to hide the default, Cut, Copy, Paste, Insert…., Delete….., Clear Contents…., Filter….., Sort…, Insert Comment…., Format Cell…., Pick from Drop Down List, Define Name…., and Hyperlink….

    Something like

    Please Login or Register  to view this content.
    This Custom Right Click Menu should appear have control only in the current workbook only.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2010
    Posts
    271

    Re: Custom Right Click Menu and Sub-menu (disable inbuilt right click menu item)

    It should work in Excel 2010 and above

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Custom Right Click Menu and Sub-menu (disable inbuilt right click menu item)

    If you are no longer using Excel 2007, please update your profile accordingly. Thanks.
    Last edited by AliGW; 01-28-2020 at 05:50 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Custom Right Click Menu and Sub-menu (disable inbuilt right click menu item)

    Hi. I've got similar code somewhere but I suggest you read here, I used this to customise it to my needs
    https://www.rondebruin.nl/win/s6/win001.htm

    One TIP: use the Workbook_BeforeClose trigger to remove the context menu and restore it to the default or else it will remain active for other workbooks.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-17-2017, 04:50 PM
  2. Custom right click menu item inside catalogue doesn't work
    By Temporary-Failure in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2015, 05:32 AM
  3. A macro to right click a cell and select a item from the right click menu?
    By Peavey in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2014, 10:55 AM
  4. Persistent custom right-click shortcut menu item
    By ahartman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2009, 01:21 PM
  5. Add menu item to right-click menu
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2006, 05:35 AM
  6. Adding Sub Menu Item to Current Custom Menu
    By Renato in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2005, 08:55 PM
  7. [SOLVED] disable right click menu
    By JT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1