I am creating a command bar (“tool bar,” to most of us) in code, and adding controls to it. I want the bar to appear vertically, so I track the width of the widest control as they are added, and then set the command bar width to that value. In order to offset some of the controls visually I add a spacer by setting their “.BeginGroup” property to True.
This works very well in XL 2000 – the tool bar is vertical with a group of four controls, a nice horizontal “etched” line, another control, another line, and then a further four controls. When I run the same code on XL 2003, the spacing does not show up. If the Command Bar is set wide enough to show all the controls horizontally then I can see that the “BeginGroup” setting has been applied – there are (little) vertical spacers here they are supposed to be – it is only on the vertical (narrow) orientation that I have problems. Am I missing a setting for how XL2003 displays Command Bars? As an aside, the command bar looks ghastly on XL 2003, but I suppose that is a matter of taste.
so ugly, as well; granted, it’s a matter of taste, but they are a step backwards from XL 2K.
