Remove Strike Through content in Excel

[syi (David Yi)]

Hello,

I have a excel file that has strike through data, is it possible to remove all strike through information from the excel sheet?

[jack.chan]

1. add the below code to a file e.g. vba.txt

Function RemoveStrikeThrough(sheetName As String)
    ActiveWorkbook.Sheets(sheetName).Activate
    Cells.Select
    Selection.Font.Strikethrough = False
    ActiveWorkbook.Save
End Function

2. in excel application scope, call invoke vba activity
   pass in filepath= vba.txt
   methodname = “RemoveStrikeThrough”
   parameters = {"Sheet1"} (or your own sheet name)
   
   

[syi (David Yi)]

That worked
Thank you!!!