Current selection box

[Anonymous]

Is there a way to supress the horizontal scroll bar on a current selections box

[#2]

Not that I'm aware of, but consider this, If you were able to supress the horizontal scroll bar wouldn't this invalidate the purpose of the current selection box. Namely keeping the user aware of the selections made to understand the meaning of the charts.

[Anonymous]

The intention is that there would be enough abbreviated info and the pop-up text would provide the rest

[erichshiino]

You can use a text box as a work-around.

You can use the expression:

=getcurrentselections()

Then, you adjust the size you need and go to object properties -> caption -> Help text and use the same expression there.

but I agree with Richard, this can make the be less useful than a current selection box with the appropriate space.

Regards,

Erich

[Anonymous]

Thanks, decided to stay with scroll bar

[kji]

You can make a macro that changes the column widths, and set them so low that the scrollbar disappears.

Actual values will of course depend on the size of you currentselections box

sub SetWidths

    set cs = ActiveDocument.GetSheetObject("CS01")

    dim w(2)

    w(0) = 100

    w(1) = 50

    w(2) = 50

    cs.SetPixWidths w

end sub