 |
Newsgroups: microsoft.public.excel
From: "Kenneth Ho" <ho...@hknet.com>
Date: Mon, 17 Jul 2006 11:33:31 +0800
Local: Mon 17 July 2006 04:33
Subject: A lot of Text Boxes!
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, You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: "Jim Cone" <jim.cone...@rcn.comXXX>
Date: Sun, 16 Jul 2006 20:46:26 -0700
Local: Mon 17 July 2006 04:46
Subject: Re: A lot of Text Boxes!
You don't know why?
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Kenneth Ho" Hello all, Regards, You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: "Bob Phillips" <bob....@somewhere.com>
Date: Mon, 17 Jul 2006 08:19:32 +0100
Local: Mon 17 July 2006 08:19
Subject: Re: A lot of Text Boxes!
If you remove them, do they come back?
-- Bob Phillips (replace somewhere in email address with gmail if mailing direct) You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: "Kenneth Ho" <ho...@hknet.com>
Date: Fri, 21 Jul 2006 11:53:50 +0800
Local: Fri 21 July 2006 04:53
Subject: Re: A lot of Text Boxes!
Thanks for your reply.
I can't remove them all. As there're more than 50000. Any idea? Thanks. Regards, "Bob Phillips" <bob....@somewhere.com> wrote in You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: Dave Peterson <peter...@verizonXSPAM.net>
Date: Fri, 21 Jul 2006 07:40:20 -0500
Local: Fri 21 July 2006 13:40
Subject: Re: A lot of Text Boxes!
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 Dim myShape As Shape For Each myShape In ActiveSheet.Shapes For Each OLEObj In ActiveSheet.OLEObjects The top portion deletes the textboxes from the Drawing toolbar. The bottom If you're new to macros, you may want to read David McRitchie's intro at: Dave Peterson You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: Dave Peterson <peter...@verizonXSPAM.net>
Date: Fri, 21 Jul 2006 07:41:08 -0500
Local: Fri 21 July 2006 13:41
Subject: Re: A lot of Text Boxes!
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: Azim Lakha <Azim La...@discussions.microsoft.com>
Date: Thu, 14 Sep 2006 02:54:01 -0700
Local: Thurs 14 Sep 2006 10:54
Subject: Re: A lot of Text Boxes!
Hi Kenneth Ho,
did you manage to remove all this text boxes? i am having the same problem. any ideas pls. thank you You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||
|
Newsgroups: microsoft.public.excel
From: Dave Peterson <peter...@verizonXSPAM.net>
Date: Thu, 14 Sep 2006 07:38:32 -0500
Local: Thurs 14 Sep 2006 13:38
Subject: Re: A lot of Text Boxes!
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/th... Dave Peterson You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||