Prev: Hyperlink
Next: Using Formatted Text with AutoCorrect in Excel
From: Zarky des Bois ! on 26 Apr 2010 10:59
Hi,

I had a problem with multiple custom cell styles that don't allow me
to convert an excel 2007 file to excel 2003.

I found a VBA example to delete all those custom cell styles easily:
Sub style_remove()
On Error Resume Next
Dim mpStyle As Style
For Each mpStyle In ActiveWorkbook.Styles
If Not mpStyle.BuiltIn Then
mpStyle.Delete
End If
Next mpStyle
End Sub

But there are some recalcitrant custom cell styles like:
386grabber=VGA.3GR
_100301_VC outlook Oral Care France
shell=progman.exe
m
AeE­ [0]_INQUIRY ¿µ¾÷AßAø
AeE­_INQUIRY ¿µ¾÷AßAø
AÞ¸¶ [0]_INQUIRY ¿?¾÷AßAø
AÞ¸¶_INQUIRY ¿?¾÷AßAø
C?AØ_¿?¾÷CoE²
C?AØ_¿µ¾÷CoE²
Ò»°ã_BRANDTTL
Porcentagem_06'97
??_(A1)BOQ

and even if I try to delete them manually, I hear a system sound (but
no error message is displayed) and the cell styles selection screen is
closed before I can right-click on custom cell style. It looks like
invalid character...

do you have an idea to definitively delete those recalcitrant custom
cell styles ??

Many thanks, Zarkoff
 | 
Pages: 1
Prev: Hyperlink
Next: Using Formatted Text with AutoCorrect in Excel