Customizing Menus in Excel 2007

L

Loris

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
 
J

Jim Rech

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
| 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
 

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

Top