附件中的总分平衡表中有代码,导出时代码一同导出,怎么改能把导出的
代码删除?
Sub 报表输出()
Application.ScreenUpdating = False
w = Array("资产负债表", "利润表", "总分平衡表")
Sheets(w).Select
Sheets(w).Copy
For i = 1 To UBound(w) + 1
Sheets(Array(i)).Select
ActiveSheet.Unprotect
For Each shp In ActiveSheet.Shapes
shp.Delete
Next
Next i
Application.ScreenUpdating = True
End Sub