ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Customizing Menus in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/176352-customizing-menus-excel-2007-a.html)

Loris

Customizing Menus in Excel 2007
 
In Excel 2003 I was able to add a menu and then add macros to it. I was also
able to add macros to custom buttons to any toolbar. In 2007 I can create a
custom button within a workbook to which I can add a macro, but how do I add
it to the ribbon bar? How do I add a button with a macro assigned to it to
the Quick Access Toolbar? Incidentally, I'm still using Windows XP. Thanks

Jim Rech[_2_]

Customizing Menus in Excel 2007
 
Ron de Bruin has information here on customizing the QAT:

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

Also information on changing the ribbon itself:

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

--
Jim
"Loris" wrote in message
...
| In Excel 2003 I was able to add a menu and then add macros to it. I was
also
| able to add macros to custom buttons to any toolbar. In 2007 I can create
a
| custom button within a workbook to which I can add a macro, but how do I
add
| it to the ribbon bar? How do I add a button with a macro assigned to it to
| the Quick Access Toolbar? Incidentally, I'm still using Windows XP.
Thanks




All times are GMT +1. The time now is 04:40 AM.

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