I have a lot of old custom cell styles cluttering up my drop-down menu. It is painful deleting them one by one as I have created a lot over the years (wqithout even realizing I have created them). I now want to delete the lot and start new. Does anyone have any ideas?
(Solved) - How do I remove custom cell styles ?(8 posts)
you can try the solutions provided here. I tested the macro (I'm using Excel 2007) and it worked fine except that one of the custom styles is used in some of my macros which failed after I deleted all the custom styles. I had to re-define that custom style. Luckily it was only that one (so far).
The one that is shown on the page - here it is
Dim mpStyle As Style
For Each mpStyle In ActiveWorkbook.Styles
If Not mpStyle.BuiltIn Then
This topic has been closed to new replies.