Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

A lot of Text Boxes!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kenneth Ho - 17 Jul 2006 04:33 GMT
Hello all,
   I got a problem on my excel files.  Hope you may help.
   I don't know why, many of my excel files have a huge number of Text
Boxes.  It's over 50,000 and they're all empty.  As a result, it slows down
my computer.  Whenever I edit the files, it takes more than 10 seconds to
move one cell to another.  So, I can't do anything on them anymore.
   I've checked my computer and it's no virus.  I'm still using Excel 97.
Any one of you have the same experience?  Why this happened?  You will help
me a lot if you could solve my problem.  Many thanks!

Regards,
Kenneth Ho
Jim Cone - 17 Jul 2006 04:46 GMT
You don't know why?
Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Kenneth Ho"
<hoken@hknet.com>
wrote in message

Hello all,
   I got a problem on my excel files.  Hope you may help.
   I don't know why, many of my excel files have a huge number of Text
Boxes.  It's over 50,000 and they're all empty.  As a result, it slows down
my computer.  Whenever I edit the files, it takes more than 10 seconds to
move one cell to another.  So, I can't do anything on them anymore.
   I've checked my computer and it's no virus.  I'm still using Excel 97.
Any one of you have the same experience?  Why this happened?  You will help
me a lot if you could solve my problem.  Many thanks!

Regards,
Kenneth Ho

Bob Phillips - 17 Jul 2006 08:19 GMT
If you remove them, do they come back?

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hello all,
>     I got a problem on my excel files.  Hope you may help.
[quoted text clipped - 8 lines]
> Regards,
> Kenneth Ho
Kenneth Ho - 21 Jul 2006 04:53 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.