XL2000: How to Programmatically Reset a Workbook to Default Styles

Sub RebuildDefaultStyles()

'The purpose of this macro is to remove all styles in the active
'workbook and rebuild the default styles. "Normal" cannot be
'deleted. Therefore the macro does not attempt to delete it.
'It rebuilds the default styles by merging them from a new workbook.

    'Dimension variables.
    Dim MyBook As Workbook
    Dim tempBook As Workbook
    Dim CurStyle As Style
    
    'Set MyBook to the active workbook.
    Set MyBook = ActiveWorkbook
    
    'Delete all the styles in the workbook.
    For Each CurStyle In ActiveWorkbook.Styles
        If CurStyle.Name <> "Normal" Then CurStyle.Delete
    Next CurStyle

    'Open a new workbook.
    Set tempBook = Workbooks.Add
    
    'Disable alerts so you may merge changes to the Normal style
    'from the new workbook.
    Application.DisplayAlerts = False
    
    'Merge styles from the new workbook into the existing workbook.
    MyBook.Styles.Merge Workbook:=tempBook
    
    'Enable alerts.
    Application.DisplayAlerts = True
    
    'Close the new workbook.
    tempBook.Close

End Sub