Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-24-2020, 10:42 AM
coffent coffent is offline Add item to context menu for a specific workbook Windows 10 Add item to context menu for a specific workbook Office 2019
Advanced Beginner
Add item to context menu for a specific workbook
 
Join Date: Dec 2019
Posts: 40
coffent is on a distinguished road
Default Add item to context menu for a specific workbook

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
Reply With Quote
 



Similar Threads
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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft