Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I stop my conttrols from resizing

My Excel controls change size 'randomly' How do I prevent this?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,069
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop Excel from automatically resizing my row height? Geerdad Excel Worksheet Functions 0 April 9th 10 04:40 PM
how to stop resizing of font in a resized chart Riri Setting up and Configuration of Excel 1 August 16th 09 07:04 PM
stop text box from resizing kh Charts and Charting in Excel 0 October 12th 06 09:14 PM
Stop a List Box from resizing Bob Excel Worksheet Functions 0 April 28th 06 08:46 PM
Help Stop Resizing Excel! Darren Hill[_2_] Excel Programming 2 November 5th 03 11:56 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"