Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Delete 1 row of objects, not all on sheet Excel 2007

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste EXCEL 2007 sheet into WORD 2007 - objects move around Martin L Excel Discussion (Misc queries) 5 February 29th 08 01:45 PM
Excel 2007 macros with drawing objects DMChesser Excel Discussion (Misc queries) 1 October 8th 07 09:05 PM
Printing Photos and Objects in Excel 2007 R.G. Lowe Excel Discussion (Misc queries) 0 January 13th 07 03:03 PM
how to delete multiple autoshape or objects in excel ron Excel Discussion (Misc queries) 4 January 26th 06 11:01 PM
delete multiple autoshapes or objects in excel ron Excel Discussion (Misc queries) 3 January 26th 06 03:01 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"