right click menu

:giggle: Hello everyone! This post is to find a solution for those who want to use the Right-Click menu properties of the mouse that the computer provides to the user. If Possible. This is why I was curious about the topic: -I have been learning VBA for some months, but I still want to...

Hello! I have a strange issue. On my worksheet, I initiate macros with added right-click buttons. The macro first unlocks the sheet, changes the cells' (carried via parameter) content (clears), and locks it again. During the subroutine's step-by-step debug everything works fine. However, when...

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

Hello everyone, So I have a macro called Duplication I wrote and I want to add it from the right click menu with the caption Dupliquer. I have found this code which allows it when I right click on a cell : Private Sub Workbook_Deactivate() On Error Resume Next With Application...

I am creating an add-in that adds an option to the right-click menu that will let me run my macros. I've used the functions found here but when this is saved as an add-in this functionality doesn't work anymore. What would be needed to fix this...

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

Hi Everyone, Using Excel 2013 (32bit) to build an add-in for my workplace. Done lots of this sort of thing before but new to Excel 2013. I have a userform with several controls on it, one of which is a TreeView. This TreeView control is used to display and interact with structured data from a...

Hi, I am trying to work on a spreadsheet at my work. I wanted to block the access of copy - paste on data validation cells to prevent that they would be overwritten by colleagues. I found some VBA codes on internet and tried them out. Afterwords I erased them from the file but now my right...

I am working on a vba program in excel 2010. I have figured out how to create a own mouse right click menu, when clicking on a cell. But there still pops up a second right click menu, which shows some formatting icons. What do I need to do, so that my own right click menu is shown, but the...

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