How do I stop my conttrols from resizing

  • Thread starter Thread starter technology_vision
  • Start date Start date
T

technology_vision

My Excel controls change size 'randomly' How do I prevent this?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top