Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I recently added the following code to a spreadsheet to add a right click
menu to run one of my forms/macros. The problem that I'm having is that it's adding this to every spreadsheet and also adds each time so there are multiple instances of the same right click menu item. I need some help please! Sub workbook_open() Dim NewControl As CommandBarControl Set NewControl = Application.CommandBars("Cell").Controls.Add With NewControl .Caption = "Add reservation" .OnAction = "Module3.Cust_UF" .BeginGroup = True End With End Sub Any help would be appreciated! -- EW - Analyst |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Right click menu | Excel Programming | |||
Add menu item to right-click menu | Excel Programming | |||
Right click menu | Excel Programming | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Adding menu to the mouse right click pop-up menu | Excel Programming |