Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Face ID on main menu?
Hi,
I have the following code: Set myCustMenu = cbWSMenuBar.Controls.Add(Type:=msoControlButton, befo=iHelpIndex, Temporary:=True) With myCustMenu .Style = msoButtonCaption .Caption = "Test" .FaceId = 247 .OnAction = "TryME" End With The menu bar is not displaying the face ID. Is it not possible to have a face ID n a menubar button on the main menu? if i have a sub menu control button on a popup menu it works. any idea? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Face ID on main menu?
Change msoButtonCaption to msoButtonIconAndCaption or to msoButtonIcon if you
only want to display the icon. Alternatively, don't specify the Style as it defaults to msoButtonIcon. This worked for me:- Sub Test() Dim iHelpIndex As Integer Dim myCustMenu As CommandBarButton With Application.CommandBars(1) iHelpIndex = .Controls("Help").Index Set myCustMenu = .Controls.Add(Type:=msoControlButton, _ befo=iHelpIndex, Temporary:=True) End With With myCustMenu .Style = msoButtonIconAndCaption 'msoButtonCaption .Caption = "Test" .FaceId = 247 .OnAction = "TryME" End With End Sub Sub TryMe() MsgBox "Try me !!!" End Sub Regards, Greg " wrote: Hi, I have the following code: Set myCustMenu = cbWSMenuBar.Controls.Add(Type:=msoControlButton, befo=iHelpIndex, Temporary:=True) With myCustMenu .Style = msoButtonCaption .Caption = "Test" .FaceId = 247 .OnAction = "TryME" End With The menu bar is not displaying the face ID. Is it not possible to have a face ID n a menubar button on the main menu? if i have a sub menu control button on a popup menu it works. any idea? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Face ID on main menu?
It works fine now.
Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide Main Menu Bar | Excel Worksheet Functions | |||
How can I show the name of the file on top of the Main Menu Bar | New Users to Excel | |||
Main menu is missing | Excel Discussion (Misc queries) | |||
J-walk face id menu - Problem | Excel Programming | |||
New Main menu item | Excel Programming |