How can I delete ALL text boxes in Excel worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Somehow we have hundreds of text boxes, which you can not locate unless you
are lucky enough to select one. Then we can remove them, is there a way to
remove ALL text boxes easily?
 
a macro
Sub shapescut1() 'Tom Ogilvy
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub
 
Deleting Multiple text boxes

Thanks for the how to in regard to deleting multiple text boxes. I wonder if anyone knows how they got there in the first place? We saw over 18,000.
 
Thank you very much, your macro solved a big problem!
nod.gif

I had 1,500 text box in the file. Size was 12 MB. After the macro, 82KB!

Ciao
B.


Don Guillett said:
a macro
Sub shapescut1() 'Tom Ogilvy
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)
"Jan Karel Pieterse" wrote in message
news:[email protected]...
> Hi Genesis,
>
> > Then we can remove them, is there a way to
> > remove ALL text boxes easily?
> >
>
> F5, special, Objects, del?
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> www.jkp-ads.com
>
Click to expand...
 
If anybody still needs help with this, I just posted an easy and quick guide to remove text boxes (or any object) from Excel 2003/2007 without macros on my blog.

If you search google for my blog using:

"zzoomforward blogspot excel"

You should be able to pick up a link to the blog entry on the AnandTech forum.

(I cant post links because this is my first post here)

Hope this helps someone out!

Kind Regards,
Zzoom
 
Last edited:
Back
Top