View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default 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