LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Some recalcitrant custom cell styles

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
some unknown Cell styles are shown in cell styles Vaibhav Dhawade Excel Worksheet Functions 0 March 6th 10 05:11 AM
custom created table styles TinaW Excel Worksheet Functions 6 October 25th 09 08:11 PM
Deleting All Custom Cell Styles rwmitchell32 Excel Discussion (Misc queries) 5 July 27th 09 04:43 PM
Excel Cell Styles - Quick Styles? Dean@DCF Excel Discussion (Misc queries) 0 November 15th 07 10:40 PM
The recalcitrant active cell. Rodney New Users to Excel 3 April 26th 05 08:54 PM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"