Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi,
i created an add-In which provides a menu with sub menu-entries menuMain submenu CTRL+ALT+L problem: The menu shortcut does not run. nothing happens. if I click the menu entry with the mouse, everything is ok. The shortcut is not blocked from another menu. here is the sourcecode for the menu-creation: Set cbctrl = objMenu.Controls.Add(msoControlButton) With cbctrl .Caption = "submenu" .OnAction = "CreateReport" .ShortcutText = "CTRL+ALT+L" End With can anyone help? Thank's Jens |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You would have to set the shortcut keys for the assigned onaction macro to
your shortcut key sequence. Application.OnKey "+^%l", "CreateReport" -- Regards, Tom Ogilvy "kikde" wrote in message ... hi, i created an add-In which provides a menu with sub menu-entries menuMain submenu CTRL+ALT+L problem: The menu shortcut does not run. nothing happens. if I click the menu entry with the mouse, everything is ok. The shortcut is not blocked from another menu. here is the sourcecode for the menu-creation: Set cbctrl = objMenu.Controls.Add(msoControlButton) With cbctrl .Caption = "submenu" .OnAction = "CreateReport" .ShortcutText = "CTRL+ALT+L" End With can anyone help? Thank's Jens |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is a shortcut menu? | Excel Discussion (Misc queries) | |||
Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
Add to Shortcut Menu | Excel Programming | |||
Shortcut menu help | Excel Programming | |||
shortcut menu | Excel Discussion (Misc queries) |