
Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
Thanks for your reply.
I can't remove them all. As there're more than 50000. Any idea? Thanks.
Regards,
Kenneth Ho
"Bob Phillips" <bob.NGs@somewhere.com> wrote in
message:uvUZZFXqGHA.4684@TK2MSFTNGP05.phx.gbl...
> If you remove them, do they come back?
>
[quoted text clipped - 13 lines]
>> Regards,
>> Kenneth Ho
Dave Peterson - 21 Jul 2006 13:40 GMT
You didn't answer Bob's question about if they come back.
But you could try a macro to remove the textboxes from the activesheet:
Option Explicit
Sub testem()
Dim myShape As Shape
Dim OLEObj As OLEObject
For Each myShape In ActiveSheet.Shapes
If myShape.Type = msoTextBox Then
myShape.Delete
End If
Next myShape
For Each OLEObj In ActiveSheet.OLEObjects
If TypeOf OLEObj.Object Is MSForms.TextBox Then
OLEObj.Delete
End If
Next OLEObj
End Sub
The top portion deletes the textboxes from the Drawing toolbar. The bottom
portion deletes the textboxes fom the control toolbox toolbar.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
> Thanks for your reply.
> I can't remove them all. As there're more than 50000. Any idea? Thanks.
[quoted text clipped - 28 lines]
> >> Regards,
> >> Kenneth Ho

Signature
Dave Peterson
Dave Peterson - 21 Jul 2006 13:41 GMT
ps. it may take a little time to run with all those shapes.
> Thanks for your reply.
> I can't remove them all. As there're more than 50000. Any idea? Thanks.
[quoted text clipped - 28 lines]
> >> Regards,
> >> Kenneth Ho

Signature
Dave Peterson
Azim Lakha - 14 Sep 2006 10:54 GMT
Hi Kenneth Ho,
did you manage to remove all this text boxes? i am having the same problem.
After starting a new file the problem started in this new one also. why tis
boxes are been created? any one knows? it can be an office update problem?
any ideas pls.
thank you
> ps. it may take a little time to run with all those shapes.
>
[quoted text clipped - 30 lines]
> > >> Regards,
> > >> Kenneth Ho
Dave Peterson - 14 Sep 2006 13:38 GMT
I've never seen an office update do this. But there were suggestions in that
thread how to clean things up:
http://groups.google.co.uk/group/microsoft.public.excel/browse_frm/thread/f9ec25
878c46765d/cdc03cdd5d65023a?lnk=st&q=&rnum=1&hl=en#cdc03cdd5d65023a
or
http://snipurl.com/wei0
> Hi Kenneth Ho,
>
[quoted text clipped - 44 lines]
> >
> > Dave Peterson

Signature
Dave Peterson