![]() |
#1
|
|||
|
|||
![]()
I want to add an item to the context (right-click) menu for a specific workbook. The code below does what I want, except that it adds the item for all workbook menus. Is there some way to limit the scope to a single workbook?
Sub AddItemShortCutMenu() Dim Shortcut As CommandBar Dim NewItem As CommandBarButton Set Shortcut = Application.CommandBars("Cell") Set NewItem = Shortcut.Controls.Add(Type:=msoControlButton) With NewItem .Caption = "Custom Action" .OnAction = "CustomSubroutine" 'The subroutine must be located in Module1 for some reason End With End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Context Menu Unavailable | Project Pro | Team Planner View | JKIT | Project | 0 | 12-14-2020 11:28 AM |
Remove new macros menu item | aufet | Word VBA | 1 | 11-08-2019 05:44 PM |
Powerpoint 2016 RC context menu after update | AdamC | PowerPoint | 0 | 06-26-2017 11:12 AM |
Modify right-click context menu to only allow pasting text | derajlance | Word VBA | 0 | 05-24-2016 02:25 PM |
Call for votes: office 2013 Autocorrect & right click (context menu) | franklekens | Word | 0 | 09-20-2013 12:09 AM |