You can delete all user-defined style sets. The standard SAP style set that is installed with the Add-In can not be deleted.
The style set is deleted and no longer available in the list of style sets that can be applied to a workbook.