create keybord shortcut in toolbar

[enfantter]

Hi all,

I have created an add-in which displays in the menu toolbar.

Nevertheless, i would like to add a shortcut to display the menu by using keyboard shortcut, but i dont know how to add that shortcut using vba. i want to create something like what alt + f gives you (opens the file menu)

[Andy Pope]

Check out the ShortcutText property

[enfantter]

what i actually need to do is to assaign an access key to the menu

http://office.microsoft.com/en-us/access/HP051890241033.aspx

is this posible to do through VBA ?!

[Andy Pope]

I added a menu item to the main menu, after the Help menu item.

This set ALT+Y as the keystroke to open that menu.



application.CommandBars("menu bar").Controls(11).caption="And&y's Menu"