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

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

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

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

Paula, Bob I's method should work. If these are ActiveX Controls it may not.
If this is the case, Developer -- Design Mode. Now you can blanket select
the controls and delete them without activating them.

If you done see the Developer Tab: Office Button -- Excel Options --
Popular -- Show Developer tab in the Ribbon.

If this helps please click "Yes"
<<<<<<<<<<

"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

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

Instead of using the selection pane: Home Tab -- Editing -- Find & Select
-- Select Objects.

Now you have an arrow instead of the Excel "plus". You can use the arrow to
click and drag a blanket over the objects on the sheet without actually
selecting cells.

If this helps please click "Yes"
<<<<<<<<<<

"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

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