In 2007 Add new Tool button to keep custom macros for Workbook

J

Joe

In Excel 2003 I can keep all my assigned custom macro icons under a custom
menue on the toolbar. When clicked it opens a dropdown list showing all my
macros and their name tags.
How can I do this in Excel 2007 please?
 
J

Jim Rech

There are two ways to go on this. One is to learn how to customize the
ribbon using RibbonX. The other is to do an end run around the ribbon by
putting your menuitems on a popup menu. All credit to Ron de Bruin for
developing and demonstrating the second methodology here:

http://www.rondebruin.nl/qat.htm

Ron also has plenty of information on customizing the ribbon too.

--
Jim
| In Excel 2003 I can keep all my assigned custom macro icons under a custom
| menue on the toolbar. When clicked it opens a dropdown list showing all my
| macros and their name tags.
| How can I do this in Excel 2007 please?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel 2007 Can I keep my macros under Menue button like 2003? 1
2007 store macros under Menue button as in 2003 1
How to access macros via tool buttons? 2
how do we get 2003 .xlb toolbars and custom macros to show in 07 1
Customizing Menus in Excel 2007 1
Excel 2007 custom macros/icons 2
2003 xla Add In Macro convert to 2007? 3
Make custom buttons point to local macros always 2

Top