| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selective Macro Security in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Ribbon | Excel Worksheet Functions | |||
| xls 2007 ribbon | Excel Discussion (Misc queries) | |||
| How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) | |||
| 2007 Ribbon dropdown | Excel Programming | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
