When I add a checkbox form to my spreadsheet, it is not part of any cell.
It sits above the spreadsheet and can even overlap the row/column/cell
boundary lines.

When I place them so that they look like they're "within" the cell,
inserting a row will move the cells with text down, but the checkboxes, as
you can guess, stay put.

Is there someway to stitch the checkbox form to the cell contents itself?

THANKS!!!!!!!!!!

--
With knowledge comes sorrow.

First, make sure your checkboxes are within each row (or cell).

Then rightclick on each and select Format control
then Properties tab

There's an option for moving/sizing with cells.

(The checkbox on the Forms toolbar has different options than the checkbox on
the Control toolbox toolbar.)

But the checkboxes are never gonna be attached to a cell. But they can float
over them nicely <bg>.

"Thomas G. Marshall" wrote:
>
> When I add a checkbox form to my spreadsheet, it is not part of any cell.
> It sits above the spreadsheet and can even overlap the row/column/cell
> boundary lines.
>
> When I place them so that they look like they're "within" the cell,
> inserting a row will move the cells with text down, but the checkboxes, as
> you can guess, stay put.
>
> Is there someway to stitch the checkbox form to the cell contents itself?
>
> THANKS!!!!!!!!!!
>
> --
> With knowledge comes sorrow.

--

Dave Peterson

Dave Peterson coughed up:
> First, make sure your checkboxes are within each row (or cell).
>
> Then rightclick on each and select Format control
> then Properties tab
>
> There's an option for moving/sizing with cells.
>
> (The checkbox on the Forms toolbar has different options than the
> checkbox on the Control toolbox toolbar.)
>
> But the checkboxes are never gonna be attached to a cell. But they
> can float over them nicely <bg>.



Which is probably best anyway----As long as they obey the obvious cell
movement issues, I'm happy with that.

I'd suggest though that if they were added as text elements then they would
obey center/left/right alignment, etc.... but no matter.


--
"It's easier to be terrified by an enemy you admire."
-Thufir Hawat, Mentat and Master of Assassins to House Atreides