Activex Control Object's changing Height & Width

[Debraj]

Hi forum,

I don't know, is this problem in my system, or its with other also..
My object's on the sheet are changing its size,

Can anyone, suggest me any properties, to set objects Widsth & Height fixed..
All goggling are showing code to set Width & Height in worksheet change or sheet activate method...
However i am looking for something like "AutoSize=false" / "Lock aspect ratio" + "Dont resize with cell" type method..

Can you please check if its also changing size in your system also..

 

[Debraj]

PS:

If you are also facing the same problem.. can you please test a "Regedit" option, (*** at your own risk ***)..

I have tried, restarted, and did all the suggestion from the below, but its not working in my system..

http://blogs.technet.com/b/the_micr...ng-a-print-preview-or-resolution-changed.aspx

 

[Somendra Misra]

Hi Debraj,

I could not understand your problem. When I had open your file, it showed some control such as combobox and other with fixed size. If I am zooming in the sheet the whole sheet is getting zoomed. I couldn't understand when it is getting resized in your case, I mean on what event?

P.S. I don't have an exact solution for your problem, but I just want to understand it.
Regards,

 

[Debraj]

Mishra-ji , Just start typing in the combo box, it will search the matching Item.. from the list.
In the attached file, at the same time.. its also changing size of the list box..

Can you please check this for me..
Thanks for the look..

EDIT: NO.. its still not working..

 

[Somendra Misra]

Now I see where the problem is.
Can you try this,
In Design Mode Select List Box - right click - format control - Size tab and lock aspect ratio.

Regards,

 

[Debraj]

No.. its not working.. by setting "lock aspect ratio" is this working on your system !!!

 

[Somendra Misra]

If I lock aspect ration and change Intergral height property of listbox to False, its working.

See the attached file.

 

[Debraj]

Hey thanks Mishra..

YES its working.. I dont know.. its becouse of

* Design Mode Select List Box - right click - format control - Size tab and lock aspect ratio
or * right click - Properties - locked = true..

but its working..

 

[Somendra Misra]

Welcome Debraj.