Delete 1 row of objects, not all on sheet Excel 2007
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
|