Sheet Retains Deleted Text Box Contents on HTML Export

A

Aaron Allston

My apologies if this situation has popped up before and been answered...

I have an Excel 2002 workbook of some 15 worksheets. When I first
created it, I used text boxes as footers -- each sheet was no longer
than a page when printed, so one text box per worksheet was enough, and
the use of text boxes allowed me to see the footer information without
invoking the print preview.

Later, I deleted all the text boxes and used the custom footer option
instead.

Recently, when saving those sheets as HTML files, I found that the data
that had been in those text boxes was appearing in the HTML code, even
though the text boxes were deleted. A typical example looks like this:

<v:textbox>
<div style='text-align:left'><font
class=font61058>Astro-Rangers</font><font class=font51058> 8.0<span
style='mso-spacerun:yes'> </span>2001/10/23<span
style='mso-spacerun:yes'> </span>Copyright © 2001 by Aaron
Allston</font></div>
</v:textbox>

Does anyone know how I might find and strip this antiquated text box
information from the worksheets?

Thanks in advance.

== Aaron Allston
== Writer
== [email protected]
== http://www.AaronAllston.com/
 
Top