PC Review


Reply
Thread Tools Rate Thread

Create a simple menu button

 
 
ZipCurs
Guest
Posts: n/a
 
      8th May 2009
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, before:=13)
With cmd
.Caption = "About"
.Visible = True
.OnAction = "ShowAboutInfo"
End With

Any help would be greatly appreciated.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a button drop down menu? =?Utf-8?B?Y2hyaXNwMTAyNw==?= Microsoft Frontpage 6 4th Sep 2007 02:12 PM
Create a simple menu bar =?Utf-8?B?U3RldmVu?= Microsoft Access VBA Modules 0 15th Oct 2006 06:51 AM
PP 2000: can't create button/menu in button bar to start userForm =?Utf-8?B?QmFsZXg=?= Microsoft Powerpoint 9 12th Nov 2005 10:35 PM
Create floating button based on button click in menu =?Utf-8?B?RXhjZWxNb25rZXk=?= Microsoft Excel Programming 2 12th Oct 2005 06:43 PM
How to create a toggle button on the menu? OKLover Microsoft Excel Programming 4 10th Jul 2005 03:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:26 PM.