|
放到新建模块中,反应时间比较长,耐心等待,最后弹出用时对话框说明去保护成功。就可以写入数据了。
Sub RemoveShProtect()
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
Dim i7 As Integer, i8 As Integer, i9 As Integer
Dim i10 As Integer, i11 As Integer, i12 As Integer
Dim t As String
Dim sh As Worksheet
On Error Resume Next
t = Timer
For Each sh In Sheets
sh.Activate
For i1 = 65 To 66: For i2 = 65 To 66: For i3 = 65 To 66
For i4 = 65 To 66: For i5 = 65 To 66: For i6 = 65 To 66
For i7 = 65 To 66: For i8 = 65 To 66: For i9 = 65 To 66
For i10 = 65 To 66: For i11 = 65 To 66: For i12 = 32 To 126
ActiveSheet.Unprotect Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) _
& Chr(i6) & Chr(i7) & Chr(i8) & Chr(i9) & Chr(i10) & Chr(i11) & Chr(i12)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Next
MsgBox "解除工作表保护!用时" & Format(Timer - t, "0.00") & "秒"
End Sub |
|