Checkboxs and option buttons "move and size with cells" - don't

[wpryan]

Hi All, I have a worksheet that previously had some "Yes / No" options in a drop-down list in various cells. This is a workflow checklist... I decided to replace the dropdown lists with checkboxes to facilite data entry. The workflow is dependent on the selection in a different worksheet, which hides or shows certain rows depending on the selection.
I added the checkboxes and option buttons with the default selection "move and size with cells", and assigned the output to certain cells. I then modified the code to hide a row, expecting that the rows under it that also have checkboxes, will move with the rows. It isn't happening. See code below. I made a small video, converted it to .gif format and tried uploading it, but apparently either the size of 728 kb or dimensions 1024 x 576 are too big for the upload.

If Model <> "Z8 or Z8 Neo" And Purpose = "Preventive Maintenance" Then
            With Sheets("PM")
                'Exchange Consumables
                .Rows("12").Hidden = True
                .Shapes("optPM_R9.1").Visible = False
                .Shapes("optPM_R9.2").Visible = False
                .Shapes("fr_R9").Visible = False
            End With
 End If

 

[wpryan]

OK... I discovered that if one starts hiding the rows and shapes from the bottom of the worksheet, that the checkboxes all line up correctly with the rows afterwards...