Control sizing problem

J

Jim McLeod

Dear all

Would it be possible to advise me on how to place controls within an Excel WorkSheet that are not effected by sizing actions on the sheet they are drawn upon

At the moment I have a series of checkboxes and buttons that need to be onscreen all of the time. However, when certain columns are hidden the controls within the columns are also hidden. I basically want the controls to be immune to this type of action

You help is appreciated

Ji
 
A

Andy Pope

Hi Jim,

On the Properties tab of the Format Control dialog is a Object
Positioning choice. Select "Don't Move or size with cells"

If you press the 'Select Object' button (White arrow on Drawing Toolbar)
you should be able to select multiple controls and apply the change in
a single step.

Note this will not keep controls inview if you scroll up/down or left/right.

Cheers
Andy
 
Top