I've got some forms controls on a sheet, a few checkboxes inside a
group box. When a macro inserts rows on the sheet, the box stretches,
the checkboxes separate from one another, and general havoc is wreaked
on my painstaking layout. How to stop.

-mwt

try these steps:

1. right click on the control.
2. select Format Control
3. In the Properties tab, select "Don't move or size with cells"



--
Hope that helps.

Vergel Adriano


" wrote:

I've got some forms controls on a sheet, a few checkboxes inside a
group box. When a macro inserts rows on the sheet, the box stretches,
the checkboxes separate from one another, and general havoc is wreaked
on my painstaking layout. How to stop.

-mwt

Right click the control and select Format Control. As a guess you have
checked Move and Size with Cells. Change that as you see appropriate.
--
HTH...

Jim Thomlinson


" wrote:

I've got some forms controls on a sheet, a few checkboxes inside a
group box. When a macro inserts rows on the sheet, the box stretches,
the checkboxes separate from one another, and general havoc is wreaked
on my painstaking layout. How to stop.

-mwt

"Right click the control and select Format Control. As a guess you
have
checked Move and Size with Cells. Change that as you see appropriate."

Hmmm, I had done that, but now I realize that, even though they're
grouped, I guess I need to change that for every single control?