The size of the ActiveX ListBox control shrinks

[Rob Flott]

I am unable to maintain a set size of the ActiveX Listboxes on my
Excel worksheet.

In Properties I set the size of each to a height of 40 and width of
240 and use the font Arial-Regular-14

After saving the file and then re-opening the sizes change to a height
of 22.5 and width of 148.5

Is there a way to lock the size so it does not change? In Properties
I have 'Locked' set at 'True'.

I appreciate any help with this issue. Also if you could direct me to
where I can learn more about the Properties of ActiveX Controls.

Thank you

 

[Angus Beaumont]

I am unable to maintain a set size of the ActiveX Listboxes on my
Excel worksheet.

In Properties I set the size of each to a height of 40 and width of
240 and use the font Arial-Regular-14

After saving the file and then re-opening the sizes change to a height
of 22.5 and width of 148.5

Is there a way to lock the size so it does not change?  In Properties
I have 'Locked' set at 'True'.

I appreciate any help with this issue.  Also if you could direct me to
where I can learn more about the Properties of ActiveX Controls.

Thank you

in the properties try changing the integralheight to "False", I had a
similiar problem and that worked for me

 

[Rob Flott]

in the properties try changing the integralheight to "False", I had a
similiar problem and that worked for me- Hide quoted text -

- Show quoted text -

Angus, Thank you...that worked...