Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make/add own msoControlSplitButtonPopup?
Hi there,
I have bunch of macros and i like to add them in command bar. Problem is, I want to use msoControlSplitButtonPopup for one group of macros and regular msoControlButton for the rest of the macros. Is it possible to create/use own msoControlSplitButtonPopup? If it is, please assist. Any advice is triple appreciated. Thanks! musa.biralo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make/add own msoControlSplitButtonPopup?
Why do you need msoControlSplitButtonPopup?
If you are trying to add a drop-down menu to your command bar so that your extra group of macros can be hidden until needed, then simply place a New Menu item on your command bar. Then add the buttons to call the extra macros to this new menu. 1. Bring up the Customize dialog box. 2. Click on the Commands tab. 3. Scroll to the bottom of the Categories list box and click on "New Menu". 4. In the Commands list box, drag the "New Menu " item onto the right end of your command bar. 5. Add more buttons to this new menu bar. 6. Assign macros to each button and attach the command bar to the workbook, as usual. -- Regards, Bill Renaud |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make/add own msoControlSplitButtonPopup?
Previous post was for Excel 2000. It will not exactly be what you are
looking for, if you are using Excel 2007 with the new Ribbon UI (User Interface). -- Regards, Bill Renaud |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make/add own msoControlSplitButtonPopup?
musa.biralo wrote on 10/07/2007 15:49 ET :
Hi there, I have bunch of macros and i like to add them in command bar. Problem is, I want to use msoControlSplitButtonPopup for one group of macros and regular msoControlButton for the rest of the macros. Is it possible to create/use own msoControlSplitButtonPopup? If it is, please assist. Any advice is triple appreciated. Thanks! musa.biralo I have the same problem... if you find any solution please inform me. Kind Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
How do I make make comment format default? | Excel Discussion (Misc queries) | |||
make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) |