01/04/2005 21:30:44
Rob Bovey wrote in message


"purple" wrote in message
...
I have created a floating commandbar with 3 buttons.
When it shows, the shape defaults to 1 button deep by 3
wide. I can change the shape on screen by using the
mouse to show 3 deep by 1 wide but how can I
programatically do this? It's like doing a wrapround,
squeeze the width and increase the height. '.Height'
resizes the buttons ok but does not work on the bar.
I'd appreciate any views.

Hi Purple,

If you set the Width property of your command bar to the width
of one
button, the buttons should stack automatically. The width of a
standard
command bar button is 39, so the following should do the trick:

CommandBars("YourBarName").Width = 39

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm