How to Delete Cell Styles

[mikeTRON]

I have attached a workbook that shows some excel cell styles that I simply cannot delete manually or via vba.

I use the default cell styles (input, calculation etc etc) because I like to keep my models as clean and organized as possible. When there are 10 rogue/phantom cell styles I can't delete it drives me crazy.
I have a piece of code I run to clear the cell styles (as this file originally had about 65,000 cell styles!!!) but for some reason it will NOT clear the remaining.
Can anyone help?

Code used to purge non default cell styles:

Please Login or Register  to view this content.

[mikeTRON]

Jeez.

So I found a method that works.

http://www.mrexcel.com/forum/excel-q...ml#post2687875

It is extremely stupid that you have to modify the file like that, but it DOES work.