Problem with Excel 2003 toolbars in Excel 2007

[Eric Falzon]

Hi!

I just performed migration to Excel 2007 and I'm a little confused by
some behavior of my old (Excel 2003) toolbars and VBA code...

I have created a pattern for little applications based on custom
toolbars generated by VBA code where I
use controls of these types:
* ControlPopup (menu and submenu)
* ControlButton (Button or option of a menu)
* ControlEdit
* ControlDropdown
* ControlComboBox

I have no problem with Excel 2003 using ControlEdit, ControlDropdown or
ControlComboBox in a menu (or submenu).

It is slightly different when I use it with Excel 2007:

No problem with ControlPopup and ControlButton whatever the level I put
the items.
But ControlEdit, ControlDropdown or ControlComboBox are not displayed if
they are not at first level (directly in the toolbar).
By the way they are displayed only if at the first level!

I checked in debug mode: I looked at the toolbar just before the end of
the procedure that creates all the stuff: The controls are there but
they are not displayed!

Any idea how to have ControlEdit, ControlDropdown or ControlComboBox
displayed whatever the level?

Thanks in advance.

 

[Jon Peltier]

Hi Eric -

I just performed migration to Excel 2007

You have our condolences. The UI is not amenable to such customizations.
However, some smart people have figured out how to make it work for you.

Patrick Schmid
http://pschmid.net/office2007/customize/index.php

Ron de Bruin
http://www.rondebruin.nl/ribbon.htm

- Jon

 

[Eric Falzon]

Hi Eric -


You have our condolences. The UI is not amenable to such customizations.
However, some smart people have figured out how to make it work for you.

Patrick Schmid
http://pschmid.net/office2007/customize/index.php

Ron de Bruin
http://www.rondebruin.nl/ribbon.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

Thanks for the answer even it is not exactly what I expected.