Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pimp my custom menu (want to display FaceIds and shortcuts combo)?
I've got the following code for a custom menu and it's working fine BU how can I add FaceIds to the menu items? Is it also possible to sho the custom shortcuts like they are showed in the default menu's (e.g Ctrl+S for _S_ave in menu _F_ile? PHP code ------------------- ' ' Macro found @ www.romanpress.com/Articles/Menus_R/Menus.htm ' Made some minor adjustments only ' Private Sub AddMenu() Dim cbpop As CommandBarControl Dim cbctl As CommandBarControl Dim cbsub As CommandBarControl Dim cbpos As Integer On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("Custom Menu").Delete On Error GoTo 0 ' Create a popup control on the main menu bar cbpos = Application.CommandBars("Worksheet Menu Bar").Controls("Help").Index Set cbpop = Application.CommandBars("Worksheet Menu Bar"). _ Controls.Add(Type:=msoControlPopup, Befo=cbpos) cbpop.Caption = mname cbpop.Visible = True ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "&Update rapport" cbctl.OnAction = "UpdateRapport" ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "&Print all sheets" cbctl.OnAction = "PrintAllSheets" ' Add a popup for a submenu Set cbsub = cbpop.Controls.Add(Type:=msoControlPopup) cbsub.Visible = True cbsub.Caption = "Rapport op&slaan als..." ' Add submenu item Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "Save As (Preformatted)" cbctl.OnAction = "SaveAs" ' Add submenu item Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "Save Copy As (Preformatted)" cbctl.OnAction = "SaveCopyAs" End Su ------------------- -- s80N ----------------------------------------------------------------------- s80NL's Profile: http://www.excelforum.com/member.php...fo&userid=3637 View this thread: http://www.excelforum.com/showthread.php?threadid=56178 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "pimp" (with FaceIds and shortcuts combo) a custom menu?
Hi, Not a expert ob VBA but think it's .FaceId = then the number The link will help with what number has what faceid http://www.j-walk.com/ss/excel/tips/tip67.htm Not sure how to underline the text to display a shortcut VBA Noo -- VBA Noo ----------------------------------------------------------------------- VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383 View this thread: http://www.excelforum.com/showthread.php?threadid=56178 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "pimp" (with FaceIds and shortcuts combo) a custom menu?
Hi Again, If you add a macro button. Then Change it's name. Put a "&" before th letter you want underlined. VBA Noo -- VBA Noo ----------------------------------------------------------------------- VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383 View this thread: http://www.excelforum.com/showthread.php?threadid=56178 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pimp my custom menu (want to display FaceIds and shortcuts combo)?
Hi s80NL,
Try changing your first control code to something like: ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) With cbctl .Visible = True .Style = msoButtonIconAndCaption .Caption = "&Update rapport Shift-Ctrl+P" .OnAction = "UpdateRapport" .FaceId = 2817 End With --- Regards, Norman "s80NL" wrote in message ... I've got the following code for a custom menu and it's working fine BUT how can I add FaceIds to the menu items? Is it also possible to show the custom shortcuts like they are showed in the default menu's (e.g. Ctrl+S for _S_ave in menu _F_ile? Formula: -------------------- ' ' Macro found @ www.romanpress.com/Articles/Menus_R/Menus.htm ' Made some minor adjustments only ' Private Sub AddMenu() Dim cbpop As CommandBarControl Dim cbctl As CommandBarControl Dim cbsub As CommandBarControl Dim cbpos As Integer On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("Custom Menu").Delete On Error GoTo 0 ' Create a popup control on the main menu bar cbpos = Application.CommandBars("Worksheet Menu Bar").Controls("Help").Index Set cbpop = Application.CommandBars("Worksheet Menu Bar"). _ Controls.Add(Type:=msoControlPopup, Befo=cbpos) cbpop.Caption = mname cbpop.Visible = True ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "&Update rapport" cbctl.OnAction = "UpdateRapport" ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "&Print all sheets" cbctl.OnAction = "PrintAllSheets" ' Add a popup for a submenu Set cbsub = cbpop.Controls.Add(Type:=msoControlPopup) cbsub.Visible = True cbsub.Caption = "Rapport op&slaan als..." ' Add submenu item Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "Save As (Preformatted)" cbctl.OnAction = "SaveAs" ' Add submenu item Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "Save Copy As (Preformatted)" cbctl.OnAction = "SaveCopyAs" End Sub -------------------- -- s80NL ------------------------------------------------------------------------ s80NL's Profile: http://www.excelforum.com/member.php...o&userid=36374 View this thread: http://www.excelforum.com/showthread...hreadid=561781 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pimp my custom menu (want to display FaceIds and shortcutscombo)?
How about...
Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) With cbctl .Visible = True .Style = msoButtonIconAndCaption .Caption = "&Update rapport" .ShortcutText = "Ctrl-M" .OnAction = "UpdateRapport" .FaceId = 2817 End With Application.MacroOptions Macro:="UpdateRapport", _ HasShortcutKey:=True, ShortcutKey:="M" s80NL wrote: I've got the following code for a custom menu and it's working fine BUT how can I add FaceIds to the menu items? Is it also possible to show the custom shortcuts like they are showed in the default menu's (e.g. Ctrl+S for _S_ave in menu _F_ile? Formula: -------------------- ' ' Macro found @ www.romanpress.com/Articles/Menus_R/Menus.htm ' Made some minor adjustments only ' Private Sub AddMenu() Dim cbpop As CommandBarControl Dim cbctl As CommandBarControl Dim cbsub As CommandBarControl Dim cbpos As Integer On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("Custom Menu").Delete On Error GoTo 0 ' Create a popup control on the main menu bar cbpos = Application.CommandBars("Worksheet Menu Bar").Controls("Help").Index Set cbpop = Application.CommandBars("Worksheet Menu Bar"). _ Controls.Add(Type:=msoControlPopup, Befo=cbpos) cbpop.Caption = mname cbpop.Visible = True ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "&Update rapport" cbctl.OnAction = "UpdateRapport" ' Add menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "&Print all sheets" cbctl.OnAction = "PrintAllSheets" ' Add a popup for a submenu Set cbsub = cbpop.Controls.Add(Type:=msoControlPopup) cbsub.Visible = True cbsub.Caption = "Rapport op&slaan als..." ' Add submenu item Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "Save As (Preformatted)" cbctl.OnAction = "SaveAs" ' Add submenu item Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True cbctl.Style = msoButtonCaption cbctl.Caption = "Save Copy As (Preformatted)" cbctl.OnAction = "SaveCopyAs" End Sub -------------------- -- s80NL ------------------------------------------------------------------------ s80NL's Profile: http://www.excelforum.com/member.php...o&userid=36374 View this thread: http://www.excelforum.com/showthread...hreadid=561781 -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "pimp" (with FaceIds and shortcuts combo) a custom menu?
Thanks to all of you for replying. I got it working with the WITH metho : -- s80N ----------------------------------------------------------------------- s80NL's Profile: http://www.excelforum.com/member.php...fo&userid=3637 View this thread: http://www.excelforum.com/showthread.php?threadid=56178 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Display of Keyboard Shortcuts in MenuBar and/or Ribbon | Setting up and Configuration of Excel | |||
formatting combo box on custom menu | Excel Programming | |||
menu bar keyboard shortcuts intermittent. | Excel Programming | |||
How do I display all assigned keyboard shortcuts? | New Users to Excel | |||
FaceIDs for VBE Menus | Excel Programming |