ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In 2007 Add new Tool button to keep custom macros for Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/168839-2007-add-new-tool-button-keep-custom-macros-workbook.html)

Joe

In 2007 Add new Tool button to keep custom macros for Workbook
 
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?

Jim Rech[_2_]

In 2007 Add new Tool button to keep custom macros for Workbook
 
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 he

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

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

--
Jim
"Joe" wrote in message
...
| 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?




All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com