SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Microsoft Office

(Solved) - How do I remove custom cell styles ?

(8 posts)
  • Started 5 months ago by feinui
  • Latest reply from feinui
  • Topic Viewed 541 times

  • View Accepted Answer
  • Remove Solved Status
feinui
Posts: 99

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?

Posted 5 months ago #
Top
 
germ-x
germ-x
Posts: 5310

Cell styles in what? Excel?
If Excel what version?
If not Excel what app are you referring to ?

Posted 5 months ago #
Top
 
moreeg
moreeg
Posts: 842

Hi feinui

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).

Posted 5 months ago #
Top
 
feinui
Posts: 99

Thanks moreeg, do you mean getting the the macro from Jim Crone?

Posted 5 months ago #
Top
 
moreeg
moreeg
Posts: 842

The one that is shown on the page - here it is

Sub ClrStyles()
Dim mpStyle As Style
For Each mpStyle In ActiveWorkbook.Styles
If Not mpStyle.BuiltIn Then
mpStyle.Delete
End If
Next mpStyle
End Sub

Posted 5 months ago #
Top
 
feinui
Posts: 99

Thanks. So I put this in as a macro and run it?

Posted 5 months ago #
Top
 
moreeg
moreeg
Posts: 842

yes. do you know how to do that?

Accepted Answer · Posted 5 months ago #
Top
 
feinui
Posts: 99

Thank you so so much. It worked !

Posted 5 months ago #
Top