ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I stop my conttrols from resizing (https://www.excelbanter.com/excel-programming/442931-how-do-i-stop-my-conttrols-resizing.html)

technology_vision

How do I stop my conttrols from resizing
 
My Excel controls change size 'randomly' How do I prevent this?

Tom Hutchins

How do I stop my conttrols from resizing
 
Set the properties of the controls to not resize with cells. Right-click on
the control Format control Properties tab make sure 'Move and size
with cells' is NOT the option selected.

If you change the Zoom setting on your worksheet, your controls will grow or
shrink accordingly. AFAIK, there is no way to prevent that.

Hope this helps,

Hutch

"technology_vision" wrote:

My Excel controls change size 'randomly' How do I prevent this?



All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com