View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
BSc Chem Eng Rick BSc Chem Eng Rick is offline
external usenet poster
 
Posts: 118
Default 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