Cannot delete a custom style imported from another workbook

I've been given a workbook that had a tab copied into it from another workbook. The source workbook has evidently evolved over time, accumulating a large number of custom number formats and custom cell styles. (Over 15,000 if thisworkbook.styles.count is to be believed.)

I ran the below Excel 2007 VBA code to eliminate all but the default styles:

Please Login or Register  to view this content.

The new count of cell styles is 68.

The problem is that 19 custom styles are persistent and cannot be deleted.
Also, they cannot be selected from the styles dropdown list on the Home tab. Hovering over any of those custom styles makes the dropdown window disappear.

Examples:
_5-10-07 Mezz Sales
_Appendix_Wk 12 Est
_Appendix_Wk 13 Est Final
_Target Gaps 2

The error thrown by the code is:
Run-time error '1004:
Delete method of Style class failed


How can I delete those styles?

http://support2.microsoft.com/kb/213904 this should be helpful

Sent from my GT-N7105 using Tapatalk now Free

Hi Ron,

Have you tried the tools listed in #3 here: https://support.microsoft.com/kb/213904

Rory/sglife

Thanks for the suggestion.
That site, while promising, has the following issues for me:
1) the link to "2553085 Unused styles are copied from one workbook to another workbook in Excel 2007" goes to a site that throws a runtime error
"Server Error in '/' Application."

2) The others link to sites that my company blocks.

3) When I use my personal computer, I can access the sites (except for the Excel 2007 link). Howver, my work PC permissions don't allow me to download add-ins or access the registry.

Since the problem exists, I have to assume that my company never installed the fix that prevents unused cell styles from being copied into other workbooks when copying tabs.


Consequently, I think my only available option is to find VBA code that will kill these annoying cell styles.

Hoping for something I can use.

There's a browser based version here: http://sergeig888.wordpress.com/2011...ght-4-version/

Failing that, you may have to do manual clean up of the XML files.

Thanks, Rory....Of course, that location is also blocked.
Looks like XML-editing is in my future.

I'll mark this thread solved to get it out of the "active" listing.