View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Lock checkbox to cell?

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

Vaya con Dios,
Chuck, CABGx3


"Dave Peterson" wrote in message
...
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 wrote:

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