Active X control button not locked

[Aland2929]

I am using an Active X contol[Listbox] button in an input form. When I email the workbook to a colleague, the Listbox has expanded in size and has to be re-positioned? In properties, Locked is set to True. Am I missing something?
Thanks in advance.

[royUK]

ActiveX controls can be temperamental. Try using a Forms ListBox with set it to not move or size with cells

[Aland2929]

Thanks Roy. I will try that.

[smuzoen]

Try using the IntegralHeight property - set it to false when you initialise the form

Please Login or Register  to view this content.

The default for this item is TRUE - see http://msdn.microsoft.com/en-us/libr...ralheight.aspx
When this property is set to true, the control automatically resizes to ensure that an item is not partially displayed.

PS: Sorry - Active X as you said - worksheet control - sorry I was referring to userforms however there still is a IntegralHeight property for an active x listbox control - The problem you talk of can also occur when the zoom is not set to 100% - if the other user has a different zoom setting other than 100% then its position can change. You can try setting the top and left attribute of the control

[Aland2929]

The Actice X has some advantages. My list has a few thousand names and I can type a few letters to jump to a name which I can't do with Form. I have set IntegralHeight to false and will see if that works. Thanks.

[AlvaroSiza]

ActiveX controls can be temperamental. Try using a Forms ListBox with set it to not move or size with cells

The activeX counterpart to Roy's offering is the Placement property with a value of 1 (default is 2).

Is it larger upon reciept, or does the control grow in size after manipulation? I have had many users note growing or bloated controls (activeX only) under two specific scenarios (both of which are addressed, but not fixed microsoft bugs):

1. On and off of docking station
2. Connected to external displays (most often projectors, but have had issues with a simple external monitor).

Sadly, I'm now () considering setting the position properties programatically to force re-size those that were (or could have become) culprits.

[Aland2929]

The Active X control is larger upon receipt but setting the IntegralHeight property to False has solved the problem. Thanks.