Lock checkbox to cell?

C

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top