Command Bars

[JezLisle]

I have this code below which creates a CommandBar but my problem is that I thought the line of Code .Width 100 would make the width of the actual CommandBar increase if I adjusted that number, but this doesnt seem to be the case. The title in only shows Nursing Sta instead of Nursing Staff Rota.

How can I make the CommandBar wider than is?

Please Login or Register  to view this content.

[Andy Pope]

You can not specify the width for a toolbar. It is as wide and tall as the controls it contains.
Notice that once it is built the cursor will change as you hover near the edges but you can not stretch the toolbar beyond the space required for the controls.

You need to add some blank controls to pad the toolbar or shorten the title

The toolbar is actual has a width of 116 so the code adds non working buttons till it is wide enough.

Please Login or Register  to view this content.

[JezLisle]

Excellent thanks for that :D

I have noticed that it widens if I have the first Caption with a long caption.

Do you know where I can find out about different types of CommandBars I can look at having?

[Andy Pope]

As I said the commandbar autosizes to fit controls. So yes longer text on the buttons caption will stretch the commandbar.

Lots of info and links here.
http://www.mvps.org/dmcritchie/excel/toolbars.htm
http://www.bettersolutions.com/excel...N314927331.htm

[JezLisle]

Excellent thanks for that :D