Hidden Text Boxes In Spreadsheets

[Guest]

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.

 

[Jim Rech]

If you want to delete them all run this:

Sub ClearTextBoxes()
ActiveSheet.TextBoxes.Delete
End Sub


--
Jim
| 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