context menu

I'm using this code to load a context menu from an addin. It works, except that when the addin is deselected, the context menu still shows. The menu consists of msoControlButton and msoBarPopup. WORKBOOK Option Explicit Private Sub Workbook_Open() Call cell_menu_normal Call...

With a custom context menu, macro is run with ".OnAction". See: Customizing Context Menus with VBA in every Excel version Is there a way to run 2 macros at the same time, without creating another Sub which calls both.

I've been using this to modify the context menu (right-click) in Excel. The method below is when in Page Break preview, which is different to Normal View. "+3" is the difference, at least for Office 365. Not sure if Sort was available initially, as I may have deleted before. Trying to...

Is it possible to have a 3rd level of context menu, using traditional VBA coding? Similar to this example which uses RibbonX. Customizing Context Menus in Win Microsoft Excel 2010 and higher and also Mac Excel 2016 and higher

Hi all In my vba macro I have set it so only certain cells can be selected (the ones within the brown border) I have turned off cell right-click context menu I have disabled drag and drop etc. (Application.CellDragAndDrop = False) I thought I had unwanted user-mouse fiddling cracked, until...

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...

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...

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...

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" ?

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...

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...

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...

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...

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...

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!

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...