context menu

  1. K

    Worksheet_BeforeRightClick - run macro automatically when right click on cell and select "New Note"

    Dear Guys, I have an older macro which ran well in earlier versions: when I right clicked on a cell and selected "Insert Comment": a macro ran automatically: of course I added following code to the appropriate sheet Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As...
  2. rediffusion

    How to pull data from a Sheet to create a Context Menu? How to combine two VBA codes?

    Cross-post! I find Add-in on Ron de Bruin's page, there the whole thing pulled together with realized data Sheet. Direct link to download Workbook. The fact is that slowly becoming more buttons and this is difficult to mess around. Therefore, I liked the version of Ron de Bruin (everything is...
  3. rediffusion

    Application.CommandBars(“vbaPopup”).ShowPopup ··· how can I add `Submenu` (Ron de Bruin)?

    Cross-post is here! I have «Microsoft Office 365 2019». First of all i want to tell how <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco...
  4. rediffusion

    Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    I stumbled on this method add a `PopUp Menu` from Ron de Bruin (I olso write to him but no react). It describes how to add a "Menu" is there code to add for example "Gallery" (I'm more interested in the gallery), "ToggleButton" or "SplitButton" ?
  5. rediffusion

    Context Menu

    Hi all! Found the script "VBA" which is a little tweaked to fit your needs: Sub Special_note() Dim myComm As Comment If Not ActiveCell.Comment Is Nothing Then If MsgBox("The cell already contains a note, delete?", 4) - 7 Then ActiveCell.Comment.Delete Else: Exit Sub End...
  6. N

    Attempting to customize context menu

    Hello! I am currently trying to customize the "right click" or context menu for my project in excel 2010. After doing some online research, I was able to come across some code that seemed fairly straightforward to me for getting rid of menu options I didn't want and adding new ones in. My...
  7. V

    Customize Excel Ribbon using VBA and RibbonX

    How do i customize the particular menu which comes when you right-click on the Ribbon in Excel ? It has options like: "Add to Quick Access Toolbar" "Customize Quick Access Toolbar" "Customize Ribbon" "Minimize Ribbon" I have code to customize the normal context menus in Excel 2010 using...
  8. A

    Customizing context menus

    I am running Excel 2013. Using VBA, I have customized the context menu so that when I right-click on a cell it shows only two options: Edit Name and Remove. However, above these two remaining options, there is a rectangle with buttons representing various formatting changes I could make to the...
  9. J

    VBA SendKey for Menu Key(Context Menu Key,Application key)

    I am needing to copy something from another application SendKey "^c" will not work because for some odd reason CTRL + C manually will not work. All tho i can use the Menu Key go down to Copy and press enter and it copies just fine. Which lead me to try SendKeys ("+{F10}") but had no luck...
  10. E

    Slicer - Disable Context Menu when Right Clicking on Slicer

    Hi All, I am new to excel 2010 and I just wanted to see if there was any VBA code or point and click method to disable or prevent the context menu from displaying when right clicking on a slicer? Thanks!
  11. M

    Shapes Context menu 2007

    Hi All, I have a piece of code (pasted below) that is not displaying the context menu on shapes, in 2007 (works in 2003). The "AddRightClick" code adds an item "NEW ITEM", displayed in msgbox using "CheckRighClick" code , however does not show it when right clicked on the shape. i am not sure...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back