| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Style in Excel 2003
I have received file from other user, it has more than 1500 styles. Many a
times I am not able to apply my style in the file and shows error of Too many style. I tried to remove one by one but it take too long time and I have many such files. Is there any way for multiple selection of styles and than can delete it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Style in Excel 2003
Dim mpStyle As Style
For Each mpStyle In ActiveWorkbook.Styles If Not mpStyle.BuiltIn Then mpStyle.Delete End If Next mpStyle -- __________________________________ HTH Bob "Nimesh" wrote in message ... I have received file from other user, it has more than 1500 styles. Many a times I am not able to apply my style in the file and shows error of Too many style. I tried to remove one by one but it take too long time and I have many such files. Is there any way for multiple selection of styles and than can delete it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Style in Excel 2003
My Excel add-in "Formats & Styles" will list or delete unused
number formats and styles in the active workbook. (not tested on xl2007) It may do what you want. It is free upon email request. I ask that you use your real name and provide your geographic location. Remove xxx from my email address: XX -- Jim Cone Portland, Oregon USA "Nimesh" wrote in message I have received file from other user, it has more than 1500 styles. Many a times I am not able to apply my style in the file and shows error of Too many style. I tried to remove one by one but it take too long time and I have many such files. Is there any way for multiple selection of styles and than can delete it. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Style in Excel 2003
THIS WORKED GREAT! Thanks!
On Thursday, July 9, 2009 11:24:59 AM UTC-3, Bob Phillips wrote: Dim mpStyle As Style For Each mpStyle In ActiveWorkbook.Styles If Not mpStyle.BuiltIn Then mpStyle.Delete End If Next mpStyle -- __________________________________ HTH Bob "Nimesh" wrote in message ... I have received file from other user, it has more than 1500 styles. Many a times I am not able to apply my style in the file and shows error of Too many style. I tried to remove one by one but it take too long time and I have many such files. Is there any way for multiple selection of styles and than can delete it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Format--Style only on certain cells (Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2003 List does not preserve border style for all rows | Excel Discussion (Misc queries) | |||
| Can you access the old-style Help Index using Excel 2003? | New Users to Excel | |||
| How can i test a cell for bold style in a cell (Excel 2003)? | Excel Worksheet Functions | |||
| How do I get Excel 4.0 style markers in Excel 2003? | Charts and Charting in Excel | |||
Linear Mode
