If you used checkboxes from the Control toolbox toolbar, you can:

rightclick on each
Choose Format Control
Then on the Properties tab, select move and size with cells

If you used checkboxes from the Forms toolbar, you're out of luck. Maybe you
could replace them with checkboxes from the control toolbox toolbar.

(or write a macro that hides the checkboxes, then hides the row????)


Blue Max wrote:

We have a problem with a column of checkbox controls linked to cells. When
a group of rows is collapsed using the outline feature, the controls in the
collapsed portion of the column are eventually all stacked on top of each
other.

Then, when the outline is re-expanded, the checkbox controls are no longer
on top of the cell they were linked to in the column before collapsing the
outline. Instead, the whole group of controls is stacked over a single cell
at the bottom of the collapsed section.

How do we link the controls to the cells so that they will reappear over the
proper cells when the outline is expanded?

--

Dave Peterson