Excel 2010 Phantom Strikethrough 1

[PWD]

Good morning, I had been sent an xlsm workbook and had successfully modified it some time ago according to my user's requirements. He has just bounced it back to me as all of the cells become strikethrough as soon as anything is typed in a cell or it is populated through code, even though the cell formatting appears to contradict this. We're far too far into the process to start again with a clean sheet - as I have too many other business-critical obligations on my plate.

I tried something - that had no visible affect:

Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets
ws.Visible = xlSheetVisible
ws.Cells.Font.Strikethrough = False
Next ws

Does anyone have any idea what might be going on?

Many thanks,
D€$

 

[strongm]

Sounds to me like someone has applied an erroneous conditional formatting rule

 

[PWD]

I like what you heard!!!

[pre]=TODAY()-$C10>=730[/pre]

This was to ensure that the dates in Column "C" were roughly within the last two years, otherwise the data in that line was inadmissible/inapplicable.

Thanks.

Many thanks,
D€$