Form Controls (checkbox & groupbox) stay outside when 'Grouping Data'

Hi guys,

The sheet contains data which has Form Controls (checkboxes and groupboxes) which are kept outside when Grouping Data (via "+" button").

In 'Format Control' for each of the Check/Group Boxes has 'Object Positioning' where "Move And Size With Cells" is greyed out so you can't use that option.

Is there a way around this?

Many thanks,

Stas

Hi guys,

I've managed to find a solution to the problem without VBA using Excel 2013.

As mentioned previously the 'Object Positioning' option 'Move and Size with Cells' is greyed out but you can access it.

You need to click on every Group box or Check box, go to Format, go to Size and click on the little arrow in the bottom right corner (see pic), go to Properties and select 'Move and Size with Cells'.

Stas