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

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

Jim McLeod wrote:

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.

Jim


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy....

Jim.