Posted to microsoft.public.excel.programming

JNW

external usenet poster

Posts: 480

Delete all objects on sheet except...

I know I can use ActiveSheet.DrawingObjects.Delete to delete all drawing
objects on a sheet.

Is there a way to select all drawing objects EXCEPT for charts and text
boxes (or anything else for that matter)?
--
JNW

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Delete 1 row of objects, not all on sheet Excel 2007	Paula	Excel Discussion (Misc queries)	11	October 6th 09 05:40 PM
delete objects	Debi	Excel Discussion (Misc queries)	1	January 16th 07 06:56 PM
Delete Picture Objects	The Other Mike	Excel Programming	10	February 9th 06 06:12 PM
delete hyperlinks from graphical objects in excel sheet	v_gyku[_2_]	Excel Programming	7	September 27th 05 06:03 AM
Unable to remove Sheet objects in the Microsoft Excel Objects	Adrian[_7_]	Excel Programming	1	August 26th 04 10:49 PM

All times are GMT +1. The time now is 06:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us