ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I create custom controls on the ribbon in Excel 2007? (https://www.excelbanter.com/excel-programming/408594-how-can-i-create-custom-controls-ribbon-excel-2007-a.html)

XP

How can I create custom controls on the ribbon in Excel 2007?
 
I have custom toolbars in XL XP that I need to replace in 2007.

1) I need step-by-step examples how to alter the ribbon in Office 2007 for
Excel that changes only the current workbook and/or all workbooks;

2) Can changes made in my question 1 above be done using VBA or can it only
be done manually?

3) I need step-by-step examples how to alter/customize the QAT, also can
this be done with VBA or do I have to do it manually?

Thanks much for your assistance.

Ron de Bruin

How can I create custom controls on the ribbon in Excel 2007?
 
Hi XP

You can start with the examples in the 2007 section on my site
http://www.rondebruin.nl/tips.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"XP" wrote in message ...
I have custom toolbars in XL XP that I need to replace in 2007.

1) I need step-by-step examples how to alter the ribbon in Office 2007 for
Excel that changes only the current workbook and/or all workbooks;

2) Can changes made in my question 1 above be done using VBA or can it only
be done manually?

3) I need step-by-step examples how to alter/customize the QAT, also can
this be done with VBA or do I have to do it manually?

Thanks much for your assistance.



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

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