Resetting Cell Styles Macro (And Fixing "Normal")

[TravisBickle]

Hi

I'm hoping someone can help because we have an issue that appears to be affecting more and more of our excel sheets at work.

We have a ton of legacy sheets that had a thousand and one styles, defined name ranges etc, which made them incredibly cluttered, but also huge in size. We recently moved over to 2010 so we've been slowly recreating a lot of our sheets in 2010 and cleaning them up. But one issue we're finding is the cell styles issue, which just seems to infiltrate from legacy sheets into our new ones.

Not only does it kill my styles menu, but the "Normal" cell format is changed so that any number I enter in any cell that should just have a "Normal" format is formatted as EUR currency with 2 dp. I found this macro online:

Please Login or Register  to view this content.

So this deletes most of the superflous styles, but I still have two problems that I'd be really grateful for any help on. There are a handful of styles that still won't delete (even manually). And my normal cell format still isn't fixed unless I highlight all the cells and change them.

So what I need to do is first amend the Normal Cell Style, and then for any cell formatted as "Normal" style, select and amend all these cells to be the new "normal". Hope this makes sense. It's causing us big issues here so any help would be very much appreciated.

[xlbiznes]

Hi,

you can try something like this :

Please Login or Register  to view this content.

[TravisBickle]

Thanks so much for the help. I'm still having trouble getting rid of erroneous styles, but I used the code on the below link which fixes my "Normal" cell style issue (which was the main thing).

http://www.mrexcel.com/forum/excel-q...lete-them.html

[Richard Buttrey]

Hi,

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.