Delete 1 row of objects, not all on sheet Excel 2007

Thanks to both of you. I did not get a quick fix for that, but I learned a
lot trying.

"Bob I" wrote:

I'm afraid you have made quite a mess of the Check boxes, when you click
on the name in the Selection pane it will select the object in the
Window for you. You will need to determine what get deleted. There is no
"automatic fix"

Paula wrote:

I have lots of checkboxes layered on top of each other in the last rows of
each worksheet because I deleted columns. So, through the Selection Pane I
have no fast way of finding all of the names of the boxes and group panes.
It was not done in Activix. Is there something I am missing in your message
or some other way to do this? Thanks!

"Bob I" wrote:


Perhaps this,

Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects
to be removed, press Delete key.


Paula wrote:


Check boxes and group boxes.

"BSc Chem Eng Rick" wrote:



What objects are they?

"Paula" wrote:



I know how to remove all objects on sheet, and 1 at a time. But I only want
to delete 1 row of objects on the worksheet, not all of them. There are many
in the row, on top of each other.
Thanks, Paula

You're welcome, at least now you may choose what to delete fairly quickly.

Paula wrote:

Thanks to both of you. I did not get a quick fix for that, but I learned a
lot trying.

"Bob I" wrote:


I'm afraid you have made quite a mess of the Check boxes, when you click
on the name in the Selection pane it will select the object in the
Window for you. You will need to determine what get deleted. There is no
"automatic fix"

Paula wrote:


I have lots of checkboxes layered on top of each other in the last rows of
each worksheet because I deleted columns. So, through the Selection Pane I
have no fast way of finding all of the names of the boxes and group panes.
It was not done in Activix. Is there something I am missing in your message
or some other way to do this? Thanks!

"Bob I" wrote:



Perhaps this,

Home Tab, Find & Select, Selection Pane, CTRL + Left Click the objects
to be removed, press Delete key.


Paula wrote:



Check boxes and group boxes.

"BSc Chem Eng Rick" wrote:




What objects are they?

"Paula" wrote:




I know how to remove all objects on sheet, and 1 at a time. But I only want
to delete 1 row of objects on the worksheet, not all of them. There are many
in the row, on top of each other.
Thanks, Paula