Hide form control when grouping rows/columns

[antaeusguy]

I've added some ActiveX form control CommandButton on my sheet.

When I group the rows that contains the CommandButton, and I collapse the "+" button, the rows are all hidden except for the CommandButton.
It was all "pushed" below where the row the grouping collapse.

Does anyone have any idea to solve this issue? Thanks for your help!

 

[GlennUK]

Right click each button, choose Format Control from the shortcut menu, and in the Properties tab change the property to be Move and Size with Cells.

 

[antaeusguy]

Right click each button, choose Format Control from the shortcut menu, and in the Properties tab change the property to be Move and Size with Cells.

Thanks for the tip Glenn It works perfectly