Finding hidden Check boxes -- Hidding rows

[warren_s]

I was given a project and the prior person put check boxes on top of check boxes. Is there away to find the boxes that have other ones under them?

Also when I hide the rows that have check boxes on top of them, the boxes get all goofed up. Is there away to hide rows with check boxes and unhide them with out this happening?

Thank you in advance.
Warren

 

[mrmmickle1]

Is there away to find the boxes that have other ones under them?

Click on a checkbox. Go To the new tab on the ribbon called Drawing Tools (Format). In the Arrange Section choose Selection Pane. This will allow you to see all checkbox objects on the worksheet (Whether they are form control or activex).

Also when I hide the rows that have check boxes on top of them, the boxes get all goofed up. Is there away to hide rows with check boxes and unhide them with out this happening?

If you have form control checkboxes I think you're out of luck. Seeing as the property to move and size with cells is not available.

If they are activex then you can Right Click > Format Control > Properties > Select Move and Size with Cells