Excel 2007, can't delete a custom table style

Question

excel 2007, sp2 and 3. windows xp and 7.

i have created a custom table style (Home, Styles, Format as Table, Custom).

right clicking and chosing "delete" gives a confirmation box but then does nothing.

nor does using VBA and TableStyles("myStyle").Delete.

i've checked that no tables in the workbook are using the style.

what am i doing wrong?

thanks,

e.

Answer 1

found it.

undocumented rule.

"you can't delete a TableStyle from a workbook if one of its sheets is protected, even if that sheet does not reference that TableStyle."

annoying.

i hope someone finds this useful.

e.

Answer 2

i think you misunderstand.

i do not want to delete the table.

i do not want to clear the formatting.

i want to delete the TableStyle.

the documentation says i can.

but it does not work.

thanks,

e.

Answer 3

Deleting the table does not remove the default formatting from the Range. Hence first select a None formatting for your table as selected in the below diagramand then click 'Convert to Range' in Table Tools Design Tab.