excel2010 å¼å§/æ ·å¼å¯è½æé®é¢ï¼å¤ªå¤æ æèªå®ä¹ã
ï¼è½¬ï¼è§£å³åæ³ï¼
å¯ä»¥ç¨VBAæ¹éå é¤èªå®ä¹åå
æ ¼æ ·å¼ï¼
1.æAlt+F11æå¼VBAç¼è¾å¨ï¼å¨ä»£ç çªå£ä¸è¾å
¥ä¸å代ç ï¼
Sub DelCustomStyles()
Dim st As Style
For Each st In ActiveWorkbook.Styles
If Not st.BuiltIn Then st.Delete
Next
End Sub
2.å
³éVBAç¼è¾å¨ï¼è¿åExcelçé¢ãæAlt+F8ï¼æå¼âå®â对è¯æ¡ï¼æ§è¡âDelCustomStylesâå®å³å¯ä¸æ¬¡å é¤ææèªå®ä¹åå
æ ¼æ ·å¼ï¼èå
ç½®çåå
æ ¼æ ·å¼ä¼ä¿çã
温馨提示:答案为网友推荐,仅供参考