VBA/Excel97 Remove Styles and custom formats
Posted on 2002-03-26
I have a workbook I inherited with what seems to me hundreds of styles (format/style...) and so many custom formats (format/cell/number/customer format) I can't add any more. I have deleted many manually, but I can only delete one at a time with Excel's dialog box(s). In addition, some of the styles are "protected" and the delete button is not active.
I hope to use VBA to restore the excel defaults then add back the ones I currently need. I do not want to manually delete each one. It could literally take all day.