how to dock a control to a cell in Excel ?

L

Laurent CASTEIL

Hi,

I want to associate a checkbox control to an Excel cell so that when I
change the cell dimensions the checkbox remain centered on that cell.

Cen somebody help me ?
 
J

Jon Peltier

Hold down the Alt key while creating, moving, or resizing the control and
the edges of the control will stick to the cell boundaries. Right click on
the control, choose Format, and on the Properties tab, choose Move and Size
with Cells.

- Jon
 
L

Laurent CASTEIL

Ok with the Alt key, but when I right-click on control property, the "Move
and Size
with Cells" box is still uncheckable.
 
J

Jon Peltier

The Forms toolbar controls do not all enable the Move and Size With Cells
property. The Controls Toolbox ones do. You can switch to the Controls
Toolbox type of control, or live with the limitations of the simpler
control.

- Jon
 
L

Laurent CASTEIL

Ok, know that works.

Thanks.

Jon Peltier said:
The Forms toolbar controls do not all enable the Move and Size With Cells
property. The Controls Toolbox ones do. You can switch to the Controls
Toolbox type of control, or live with the limitations of the simpler
control.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
Click to expand...
 
Top