ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Alt command for custom menu (https://www.excelbanter.com/excel-programming/369999-alt-command-custom-menu.html)

jhahes[_75_]

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


Jim Cone

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



All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com