Deleting Several Form Control Items

[brentjohn]

Greetings,
I have a worksheet that contains several From Control Items. Ex: Options Buttons, Group Boxes, etc. I am needing to copy/paste this worksheet (creating several other worksheets) and remove several of the Form Controls. Other than selecting each of them separately, is there a way to remove them all at once?

[Maudibe]

Try the following

Please Login or Register  to view this content.

HTH,
Maud

[brentjohn]

Maud,

Thank you for the quick reply!

How do I control which rows that will be deleted. Also, I assume I create button and insert this code?

[Maudibe]

is there a way to remove them all at once?

The code removes all shapes; no rows are deleted. If you want certain rows deleted, that would be additional code to add. If you add a form button, you can assign it the macro however, the button will be removed as well. If a one-time run of the code then that is OK. If you choose to use an activeX button, while in design mode, right click > view code> paste the code in the event procedure. This button will too be removed by the code. You will always, however, be able to run the code by using Alt-F8 then run the macro.

HTH,
Maud

[brentjohn]

Maud,

Thank you for clarifying.

What code would I need to add to delete row 23 and all the Form Controls within this row?

[Maudibe]

Hi Brentjohn,

Without a sample of your spreadsheet, help me better understand what you want to do.

Here is what I am gathering:

You had initially asked to delete all the shapes on the form and it now seems as though they are all aligned on row 23. You still want to delete them all but you would like row 23 deleted as well.

Question:

Will they always be aligned on row 23 and will you always want row 23 deleted

Please Login or Register  to view this content.

OR
they may be aligned on possibly any line (with the left top corner of the control in the cell of the row) and still need to be deleted along with the row they are aligned on?

Please Login or Register  to view this content.

HTH,
Maud