|
打开密码破解不易,但编辑密码破解简单。
Sub 所有表格解密()
On Error Resume Next
Dim Sh As Worksheet
For Each Sh In Worksheets
Sh.protect DrawingObjects:=True, Contents:=True, AllowFiltering:=True
Sh.protect DrawingObjects:=False, Contents:=True, AllowFiltering:=True
Sh.protect DrawingObjects:=True, Contents:=True, AllowFiltering:=True
Sh.protect DrawingObjects:=False, Contents:=True, AllowFiltering:=True
Sh.Unprotect
Next Sh
End Sub
Sub 单张表格解密()
On Error Resume Next
Dim Sh As Worksheet
Set Sh = ActiveSheet
Sh.protect DrawingObjects:=True, Contents:=True, AllowFiltering:=True
Sh.protect DrawingObjects:=False, Contents:=True, AllowFiltering:=True
Sh.protect DrawingObjects:=True, Contents:=True, AllowFiltering:=True
Sh.protect DrawingObjects:=False, Contents:=True, AllowFiltering:=True
Sh.Unprotect
Set Sh = Nothing
End Sub |
|