如题所述
工作表保护,可以用VB来清除,
先打开受保护的工作表,按ALT+F11 按操作,(将代码拷贝进去,按F5键,就完成了)
Sub pj()
Dim sht As Worksheet
For Each sht In Worksheets
sht.Protect AllowFiltering:=True
sht.Unprotect
Next
End Sub