Excel speadsheet growing in size on its own

[dandaman99]

I'm using Excel 2001 for Mac. I have simple, single worksheets that ar
growing in size over time, up to 3MB. They are simple schedules wit
basic formatting. The only symptom I can find is that there ar
hundreds of invisible text boxes in the document. The only way to fin
them is when the cursor passes over them, it becomes clickable
However, they cannot be deleted.
I suspected a macro virus, but I have run Sophos AV and Virex, an
neither program came up with anything.

Help

 

[Dave Peterson]

You sure they're checkboxes?

I don't use macs, but this worked for me in windows-land.

Option Explicit
Sub testme01()
With ActiveSheet.TextBoxes
.Visible = True
.Delete
End With
End Sub

It tries to make all of the textboxes visible and then tries to delete them.

=====
You sure they aren't comments? Do you see a red triangle in the top right
corner of the cells that have those things?

 

[Norman Harker]

Hi Dandaman!

With no other suggestions made; a stab in the dark!

Do you have speech recognition turned on?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ken Wright]

Edit / Go To / Special / Objects will show you all the little blighters -
Careful though as it will highlight ALL objects, so if you have other stuff and
just want to delete the text boxes, then go with Dave's code.

 

[dandaman99]

Thanks to all for the help. Once I went in to Edit/Go
To/Special/Objects, I could see all the little buggers.
This problem has been unsolved for over 3 years (before I arrived).
Once again, Ken Norman and Dave.....thanks for the help!!!!

 

[Ken Wright]

You're welcome