If you want to delete them all run this:

Sub ClearTextBoxes()
ActiveSheet.TextBoxes.Delete
End Sub


--
Jim
"Josh.Bopp" wrote in message
...
| There is a hidden text box that is referenced in a single cell. That cell
| was then copied over and over again until there's something like 10,000
| hidden text boxes in the spreadsheet.
|
| Is there a script that we can run that will parse these sheets and remove
| those hidden text boxes? We need to remove these hidden text boxes, we are
| unable to find any fixes for this issue.
|
| I have the sheets included in a zip file, please feel free to take a look
at
| them as needed.
|
| http://members.cox.net/~armsja/ExcelProblems.zip
|
| Thank you in advance.
|
| --
| Josh Bopp
| James Armstrong