Selective Ribbon load in 2007

[Gordon]

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

 

[Jon Peltier]

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

 

[Gordon]

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

 

[Ron de Bruin]

Hi Gordon

Build a nice ribbon

See my RibbonX dictator example (See point 2) on this page
http://www.rondebruin.nl/ribbon.htm