Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a simple menu button
I am working in Excel 2007 and want to create a simple custom button. 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 | |||
Undo button in the context menu (right click menu) | Excel Programming | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
Create and Use Button Menu using visual Basic in Excel | Excel Discussion (Misc queries) | |||
Create floating button based on button click in menu | Excel Programming | |||
How to create a toggle button on the menu? | Excel Programming |