Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alt command for custom menu
Here is part of the code for my current custom menu bar Set cbRebuttals = cbNavigationMenu.Controls.Add(Type:=msoControlButt on) cbRebuttals.Visible = True cbRebuttals.Style = msoButtonCaption cbRebuttals.Caption = "Rebuttals" cbRebuttals.OnAction = "RebuttalsHome" Is there anyway to put a shortcut...for example...when you want to choose the file option you can hit ALT+F....and F is the trigger for file.....is there anyway to set that up for my above Example....Rebuttals where R is the trigger.... Thank you for any help -- jhahes ------------------------------------------------------------------------ jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596 View this thread: http://www.excelforum.com/showthread...hreadid=570403 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alt command for custom menu
Change...
cbRebuttals.Caption = "Rebuttals" -to- cbRebuttals.Caption = "&Rebuttals" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "jhahes" wrote in message Here is part of the code for my current custom menu bar Set cbRebuttals = cbNavigationMenu.Controls.Add(Type:=msoControlButt on) cbRebuttals.Visible = True cbRebuttals.Style = msoButtonCaption cbRebuttals.Caption = "Rebuttals" cbRebuttals.OnAction = "RebuttalsHome" Is there anyway to put a shortcut...for example...when you want to choose the file option you can hit ALT+F....and F is the trigger for file.....is there anyway to set that up for my above Example....Rebuttals where R is the trigger.... Thank you for any help -- jhahes ------------------------------------------------------------------------ jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596 View this thread: http://www.excelforum.com/showthread...hreadid=570403 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Using code from custom menu bar to a Command button | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
Custom Command Menu Bar Part 2 | Excel Programming | |||
Macro as Custom Menu Command | Excel Programming |