Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
It works fine now.
Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |