Corrupt styles in 2010: How to remove?

[thedr9wningman]

Hi,

I found this post in the <a href="http://www.excelforum.com/excel-general/494340-removing-corrupt-styles-in-an-excel-workbook.html">Excel Forums</a> and I had the same problem. It was never answered.
<code>
Hello,

How can I remove corrupt styles from an Excel 2000 workbook ?

I've tried deleteing through the menus - but that doesn't work, and I've
tried through VBA, but that fails with an error for the styles that are
corrupt. (Delete method of style class failed)
e.g.

for i=1 to activeworkbook.styles.count:debug.print
activeworkbook.styles.item(i).name:activeworkbook.styles.item(i).delete:next
i

Inspecting the names of the styles that are failing to delete displays a
couple of non-printable characters show as squares, or Yen symbols.

Any idea how to obliterate these styles?
</code>

I've written similar scripts to no avail.