Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Excel 2003 toolbars in Excel 2007
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Eric Falzon" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Excel 2003 toolbars in Excel 2007
In article ,
"Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Eric Falzon" wrote in message ... 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? Thanks for the answer even it is not exactly what I expected. -- La vraie question est : existe-t-il une vie AVANT la mort? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel 2003 toolbars to Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 save as Excel 2003 problem | Excel Discussion (Misc queries) | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Transition from Excel 2003 to 2007 (toolbars, etc.) | Excel Discussion (Misc queries) | |||
Problem loading Excel 2007 files in Excel 2003 | Excel Discussion (Misc queries) |