Styles in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

People in my company often send me their problematic Excel workbooks.
Lately, I've been seeing a number of workbooks that have thousands of styles.
I have some VBA code that loops through the styles collection and deletes
anything that's not in use. However, often times quite a few of the styles
cannot be deleted. I notice that these often have the name "Nor" and cannot
be deleted through code or manually in the user interface. Does anyone know
how this situation occurs? Does anyone know how to delete these?

Thanks!
 
Possibly corrupt or built-in styles?

If all else fails you could try round-tripping via xhtml.


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting multiple styles at once in Excel 2003 3
2002: Unable to delete Normal_xyz style inherited from workbook(xy 1
Deleting All Custom Cell Styles 5
Renaming Styles in Excel 2
Some recalcitrant custom cell styles 0
Deleting styles 2
Excel 2007 - managing Styles 1
missing styles 3

Back
Top