Posted to microsoft.public.excel.programming

Glen Mettler[_4_] Glen Mettler[_4_] is offline

external usenet poster

Posts: 70

Deleting Shapes in a worksheet

I have worksheets that contain 1 or more text boxes. I need to make copies
of these worksheets but then delete the text boxes.
I have looked at the shapes collection but I can't figure out how to
identify the number of text boxes, select them, and then delete them.

Need help.

Thanks
Glen

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
Deleting Shapes	aftamath	Excel Discussion (Misc queries)	5	November 5th 05 12:37 AM
Window Error when deleting shapes	Laguna	Excel Programming	1	June 10th 05 02:29 PM
Deleting shapes in an area	Tim	Excel Programming	2	October 27th 04 08:51 PM
Deleting shapes	Dr.Schwartz	Excel Programming	1	October 15th 04 10:18 AM
Deleting shapes	Steve	Excel Programming	4	June 16th 04 05:23 PM

All times are GMT +1. The time now is 10:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us