View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Falzon Eric Falzon is offline
external usenet poster
 
Posts: 2
Default Problem with Excel 2003 toolbars in Excel 2007

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.
--
La vraie question est : existe-t-il une vie AVANT la mort?