![]() |
shortcut for add-In menu
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 |
shortcut for add-In menu
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 |
All times are GMT +1. The time now is 10:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com