Lock checkbox to cell?

[CLR]

Hi All........
I don't use checkboxes myself, but I got asked today if there is a way to
lock them to a cell so they do not move or resize with the other cells.

TIA for any info,
Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

There are two checkboxes and they have different settings.

If you use the checkbox from the Forms toolbar, you can rightclick on it and
choose Format Control. Then on the Properties tab, you'll see two available
options:

Move but don't size with cells
Don't move or size with cells

If you use the checkbox from the Control toolbox toolbar, you can rightclick on
it and choose Format Control. On the Properties tab, you'll see the same two
options and a third:

Move and size with cells.

So if you're going to change the size of the cells (even hiding the
rows/columns), you'll want to use the checkboxes from the control toolbox.

 

[CLR]

Thanks Dave........really much appreciate.

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Thanks Dave........really much appreciate.

Vaya con Dios,
Chuck, CABGx3