Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Private Sub Workbook_AddinInstall()
On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("WB Example").Delete Set cControl = Application.CommandBars("Worksheet Menu Bar").Controls.Add With cControl ..Caption = "WB Example" ..Style = msoButtonCaption ..OnAction = "ShowWorkbooks" End With I want the "x" of .Caption = "WB Example" to be the hot key. How do I do this? Thank you, Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA:programmatically invoking menu items from Excel Worksheet menu | Excel Programming | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming |