Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Command Button
I am working in Excel 2007 and want to create a simple custom menu button in
the command bar. The button is currently under "Add Ins" on the control bar and is with other buttons that do have submenus. I don't want any other controls below it and would prefer not to have the little triangle next to it. The code below works fine expect for the negative aesthetics of the arrow next to it and the empty pull down menu which shows up below it when it put the cursor over the button. Replacing msoControlPopup with mso ControlButton results in nothing showing! Set cmd = CommandBars("Worksheet Menu Bar").Controls.Add(Type:=msoControlPopup, befo=13) With cmd .Caption = "About" .Visible = True .OnAction = "ShowAboutInfo" End With Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Command Button not available until another command buttonhas been used | Excel Programming | |||
Deselect Command Button by Selecting another Command Button | Excel Programming | |||
Simple use of ActiveX Command Button - | Excel Programming | |||
simple command button question | Excel Programming | |||
VB's Command Button vs Form's Command Button | Excel Programming |