Width of Dynamic Menu : Excel Ribbon

I have a DynamicMenu as part of an custom Excel Ribbon.

The problem I have is the the menu contains a list different length menu options.

Upon selecting a menu item I change the menu text to be the selected item text.

The ribbon then resizes the menu width to the width of the text.

Is there some way to make a ribbon element a fixed a width?

Can you post example file to illustrate the problem you are trying to avoid

Originally Posted by Andy Pope

Can you post example file to illustrate the problem you are trying to avoid

Hi Andy,
sure I will post something up on Monday.
Cheers
Richard

Andy,

Please see attached example.
LeanMenuDemo.xlsm

When selecting a menu item the controls to the right will shift left/right depending on the length of the selected menu item.

I would like to make the menu fixed width, or be able to specify a minimum and maximum width.

Rihard

You can not control the width of the menu text using a property.

You can fix the width of the group by using a label control.

Andy,

I see - that is useful.

I have utilised as a label above the menu - to make use of the space ..
LeanMenuDemo2.xlsm

Thank you very much !

Richard

Corrected download in above post

Unfortunately, I have found with Excel 2013, the trailing spaces are ignored/removed by the ribbon.
I tried using the tab character but that also is 'consumed'.

try this variation in getSelectedLabel callback.

Please Login or Register  to view this content.

That is interesting - using a the non breaking space the text then flows over into the next ribbon group.

I am starting to live with the resize behaviour of the ribbon, and have redesigned/rearranged things so the resize effect is not such a problem.

Many thanks Andy

I don't see the overflow but xl2013 does seem to strip empty characters.

You can box the label and dummy buttons to pad out the group. The buttons can have no image, CHR(160) labels and not enabled.
xl2013 still strips something from the buttons label so you need about 10 buttons. And you would need to return different length label text for xl2010 as that does honour the spaces.