quick way to remove unwanted style in excel 2003

**lelo** · 11-01-2008, 11:16 AM

hi,

i have quite a lot of excel 2003 spreadsheets which once edited and saved by excel2007.

now, i'm using back excel 2003.

(because my efficiency dropped by half by searching the command i wanted in excel2007.

)

when i open them with excel2003 again, there are a lot of styles.

i want to remove them.

but it is a tedious job to remove them one by one for these spreadsheets.

i tried style manager add-in. but it didt help at all.

is there any quick way to do it??

thanx for reading.

regards

**shg** · 11-01-2008, 11:24 AM

Here's a routine I keep in my Personal.xls for just that purpose:

Please Login or Register  to view this content.

Run ListStyles and follow the instructions...

**lelo** · 11-01-2008, 11:41 AM

shg,

i'm not so good in macro.
but with a few tries, i get this worked.
thanx for the sharing and help.

regards

**shg** · 11-01-2008, 02:33 PM

Good job, Lelo, you're welcome.

**roldcruz** · 11-23-2011, 01:44 AM

Originally Posted by shg

Good job, Lelo, you're welcome.

Hi, May I ask why do I encounter this error_the macro when executed it leads me to this code If wks Is Nothing Then..Do I need to edit the code? Thanks!