Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Command Bars (Tool Bars) (XL2003)

    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 <font color=blue>".BeginGroup"</font color=blue> 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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Command Bars (Tool Bars) (XL2003)

    It's caused by the 3D llok of commandbars in Office 2003. This cannot be turned off.

    The group dividers will be visible when you dock the command bar to the left (or right) edge of the Excel window, but then the text will be vertical...

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Command Bars (Tool Bars) (XL2003)

    <hr>It's caused by the 3D llok of commandbars in Office 2003. This cannot be turned off.<hr>

    I thought as much - that's why they llok <img src=/S/wink.gif border=0 alt=wink width=15 height=15> so ugly, as well; granted, it's a matter of taste, but they are a step backwards from XL 2K.

    Thanks for your assistance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •