Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Styles in Excel
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! |
#2
|
|||
|
|||
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 "MLoftusNYC" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |