|
Selective Ribbon load in 2007
Hi...
I've built a smart toolbar add-in for Excel 2003 that floats on my workbooks even though I have disabled the load of all menu/command bars etc. However, in 2007, it seems to be set in the ribbon and works only if the ribbon loads or unloads. Is there anyway around this? Cheers G |
Selective Ribbon load in 2007
2007 does not allow command bars. As a small concession to existing code,
the buttons from custom menus and command bars in a project like yours are stuck on the Add-Ins tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Gordon" wrote in message ... Hi... I've built a smart toolbar add-in for Excel 2003 that floats on my workbooks even though I have disabled the load of all menu/command bars etc. However, in 2007, it seems to be set in the ribbon and works only if the ribbon loads or unloads. Is there anyway around this? Cheers G |
Selective Ribbon load in 2007
Hi John.
Appreciate that. I've moved the add-in toolbar to the quick access toolbar. All I have to do now is remove the ribbon but leave the quick access toolbar with code on a workbook_open and work_book close - any ideas? Cheers Gordon... "Jon Peltier" wrote: 2007 does not allow command bars. As a small concession to existing code, the buttons from custom menus and command bars in a project like yours are stuck on the Add-Ins tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Gordon" wrote in message ... Hi... I've built a smart toolbar add-in for Excel 2003 that floats on my workbooks even though I have disabled the load of all menu/command bars etc. However, in 2007, it seems to be set in the ribbon and works only if the ribbon loads or unloads. Is there anyway around this? Cheers G |
Selective Ribbon load in 2007
Hi Gordon
Build a nice ribbon See my RibbonX dictator example (See point 2) on this page http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gordon" wrote in message ... Hi John. Appreciate that. I've moved the add-in toolbar to the quick access toolbar. All I have to do now is remove the ribbon but leave the quick access toolbar with code on a workbook_open and work_book close - any ideas? Cheers Gordon... "Jon Peltier" wrote: 2007 does not allow command bars. As a small concession to existing code, the buttons from custom menus and command bars in a project like yours are stuck on the Add-Ins tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Gordon" wrote in message ... Hi... I've built a smart toolbar add-in for Excel 2003 that floats on my workbooks even though I have disabled the load of all menu/command bars etc. However, in 2007, it seems to be set in the ribbon and works only if the ribbon loads or unloads. Is there anyway around this? Cheers G |
| All times are GMT +1. The time now is 03:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com